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

user02700
user02700 βšͺ️

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

Comments

  • GrantSmith
    GrantSmith Indiana πŸ”΄

    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