Convert integer data type to time

Question

My table lists the date and time fields as integer data types. I need to convert them to normal date formats. I have the date field done. How can I convert the time field with SQL?

Answer 1

To make a datetime from your two integers, try this expression:

cast(concat(AppointmentDate, ' ', AppointmentTime / 100, ':', AppointmentTime % 100) as datetime)

If you need just the time:

timefromparts(AppointmentTime / 100, AppointmentTime % 100, 0, 0, 0)

Use these expressions in SELECT or UPDATE statements.