Combining independent Date & Hour fields into a unified Date:Hour field (in "Date" format")

user02700
user02700 Member
in Magic ETL

I have separate Date (ex: 8/26/2020) and Hour (ex:

Comments

  • GrantSmith
    GrantSmith Coach

    Hi @user02700 

     

    You can add the number of hours to your date using an interval.

     

    This will make it a DateTime instead of a Date.

     

    `Date` + INTERVAL `Hour` HOUR
    **Was this post helpful? Click Agree or Like below**
    **Did this solve your problem? Accept it as a solution!**

Categories