Querying mysql based on date

Question

I want to query on sql (mysql) based on the date.

Something like:

Select * from table_name where e_date > 2001-12-30;

What is the right query?

I am not able to pen down my problem and get the right response from google.

What exactly do you want to do with this query? It seems to be correct with quotes. — Lion
– Lion, Commented Mar 1, 2012 at 0:09

Vince Pergolizzi · Accepted Answer · 2012-03-01 00:10:07Z

3

That's correct, you'll need to put the date around single quotes though.

answered Mar 1, 2012 at 0:10

Vince Pergolizzi

6,6223 gold badges22 silver badges16 bronze badges

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

Comments

BizApps · Accepted Answer · 2012-03-01 00:15:40Z

2

Just add closing quotes on your date.

Select * from table_name where e_date > '2001-12-30'

Check the link below:

This Site will help you out regarding date time functions

Regards

answered Mar 1, 2012 at 0:15

BizApps

6,1409 gold badges43 silver badges65 bronze badges

John Woo · Accepted Answer · 2012-03-01 00:11:28Z

1

try this:

Select * 
from table_name 
where e_date > DATE('2001-12-30');

answered Mar 1, 2012 at 0:11

John Woo

265k70 gold badges509 silver badges500 bronze badges