I have a time field in a database that I need to convert to a smalldatetime with the current date attached. I feel like I’m overthinking this but am struggling with the logic. Can somebody help?
Example:
In the table the time field has a value of 05:49:00. I need to create a smalldatetime that would be:
2024-05-01 05:49:00