Skip to content

Instantly share code, notes, and snippets.

@jeffreyiacono

jeffreyiacono/date-to-datetime-comparison.sql

Created September 11, 2012 00:27
Show Gist options
  • Save jeffreyiacono/3695030 to your computer and use it in GitHub Desktop.
Save jeffreyiacono/3695030 to your computer and use it in GitHub Desktop.
Download ZIP
comparison of date to datetimes in MySQL
Raw
date-to-datetime-comparison.sql
-- DATETIME to DATE comparison
SELECT CAST('2012-09-09 23:59:59' AS DATETIME) <= DATE('2012-09-10 00:00:00'); -- TRUE :)
SELECT CAST('2012-09-10 00:00:00' AS DATETIME) <= DATE('2012-09-10 00:00:00'); -- TRUE :)
SELECT CAST('2012-09-10 00:00:00' AS DATETIME) <= DATE('2012-09-10 23:59:59'); -- TRUE :)
SELECT CAST('2012-09-10 00:00:01' AS DATETIME) <= DATE('2012-09-10 23:59:59'); -- FALSE :(
-- and a little more proof:
SELECT CAST('2012-09-10 00:00:00' AS DATETIME) = DATE('2012-09-10 00:00:00'); -- TRUE
SELECT CAST('2012-09-10 00:00:00' AS DATETIME) = DATE('2012-09-10 00:00:01'); -- TRUE
SELECT CAST('2012-09-10 23:59:59' AS DATETIME) = DATE('2012-09-10 23:59:59'); -- FALSE
SELECT CAST('2012-09-10 00:00:00' AS DATETIME) = DATE('2012-09-10 23:59:59'); -- TRUE
Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment