Create a date field for TODAY at exactly noon

colinr
colinr
in Magic ETL

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:

STR_TO_DATE(CONCAT(CURRENT_DATE(),'12:00:00'),'%m,%d,%Y')

 

Appreciate the help!

Best Answer

  • colinr
    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.

Categories