Mysql strip time component from datetime

sql mysql datetime
abarax picture abarax · Nov 6, 2008 · Viewed 92k times · Source

I need to do a date comparison in Mysql without taking into account the time component i.e. i need to convert '2008-11-05 14:30:00' to '2008-11-05'

Currently i am doing this:

SELECT from_days(to_days(my_date))

Is there a proper way of doing this?

Answer

Robert Gamble picture Robert Gamble · Nov 6, 2008

Yes, use the date function:

SELECT date(my_date)

Related questions

MySQL Query GROUP BY day / month / year

Is it possible to make a simple query to count how many records I have in a determined period of time like a year, month, or day, having a TIMESTAMP field, like: SELECT COUNT(id) FROM stats WHERE record_date.…

Read More
Datetime equal or greater than today in MySQL

What's the best way to do following: SELECT * FROM users WHERE created >= today; Note: created is a datetime field.

Read More
How to get current date & time in MySQL?

Is there a value or command like DATETIME that I can use in a manual query to insert the current date and time? INSERT INTO servers ( server_name, online_status, exchange, disk_space, network_shares ) VALUES( 'm1', 'ONLINE', 'ONLINE', …

Read More