Date and hour values to timestamp

nmizzell · 2024-04-19T14:45:12+00:00

There was an error rendering this rich post.

Hi Domo,

I have two columns: a date column (date datatype) and an hour column (0-23 integer type).

What formula could I use to combine the two columns into a timestamp, assuming the minutes, and seconds are zero?

Thanks,

Find more posts tagged with

Try this

DATE_ADD( YourDateField , INTERVAL YourIntegerField HOUR)

Try this

DATE_ADD( YourDateField , INTERVAL YourIntegerField HOUR)