Mysql select query after certain date

Question

I am trying to pull records after a certain date using mysql query , the field type is date in my database and the query is

SELECT * FROM tickets WHERE created_on > 26-08-2011

But it is not working and also showing all before that date

Thanks

James Allardice · Accepted Answer · 2011-08-30 21:21:25Z

62

The date you are using is a string, so it needs to be placed inside quotes. Also, the format is the wrong way around:

SELECT * FROM tickets WHERE created_on > '2011-08-26'

For more information, see the MySQL docs. In particular, note the very first line:

The format of a DATE value is 'YYYY-MM-DD'. According to standard SQL, no other format is permitted.

answered Aug 30, 2011 at 21:21

James Allardice

166k22 gold badges335 silver badges316 bronze badges

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

Comments

Jordi · Accepted Answer · 2011-08-30 21:22:09Z

1

The date is defined in yyyy-mm-dd, so you should use the date as 2011-08-26. Using a date in this format is ideal for sorting as the numbers are arranged as incremental pieces. You have to use quotes on string values, see the post of James Allardice.

answered Aug 30, 2011 at 21:22

Jordi

1,37713 silver badges20 bronze badges

Comments

alresave · Accepted Answer · 2011-08-30 21:22:31Z

0

Try using quotes on the date and write dates in yyyy-mm-dd format for best results. '2011-08-26'

answered Aug 30, 2011 at 21:22

alresave

461 bronze badge

Collectives™ on Stack Overflow

Mysql select query after certain date

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related