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:

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

Appreciate the help!

Find more posts tagged with

Accepted answers

colinr

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.

All comments

colinr

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.

Quick Links

All Categories
Recent Posts
Activity
Unanswered
Groups
Best Of