MySQL SELECTING DATES

Question

I am querying some data from MySQL table, one of the column has a datatype DATETIME. Now when I do query, it includes an annoying 00:00:00 time. How can I exclude this time part when doing a select?

John Woo · Accepted Answer · 2012-11-20 06:39:33Z

2

use DATE

SELECT DATE(columnName)
FROM....

or DATE_FORMAT

SELECT DATE_FORMAT(NOW(),'%Y-%m-%d');

answered Nov 20, 2012 at 6:39

John Woo

265k70 gold badges509 silver badges500 bronze badges

Sign up to request clarification or add additional context in comments.

Collectives™ on Stack Overflow

MySQL SELECTING DATES

1 Answer 1

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

Comments

Your Answer

Sign up or log in

Post as a guest

Related