Create a date field for TODAY at exactly noon

I wish to compare dates to see if they are before or after TODAY at Noon.  the 12:00 noon part is static, but the TODAY part changes every day so I want that to be dynamic.  

I tried this but it did not seem to work:



Appreciate the help!

Best Answer

  • colinr
    Answer ✓

    Nevermind.  seemed to work just like this:  CONCAT(CURRENT_DATE(),' 12:00:00')


    Did not need the string part to compare to a date column.