CODEWITHSUNDEEP
mysql
user3751571
user3751571

Reputation: 1

how to choose a greater than date when date is in mmm-dd-yyyy format

I have a table in which the date is displayed in mmm-dd-yyyy format, I want to use a greater than in this date ( like date greater than october 2014) , can anyone suggest the sql query for this.

Upvotes: 0

Views: 405

Answers (1)

A.B
A.B

Reputation: 20445

you can format the date first then sort

  select * form table where DATE_FORMAT(date_colomn,'\%e/%c/%Y\')>your_date_here

or this one 

 select * form table where DATE_FORMAT(date_colomn,'%Y-%m-%d')>your_date_here

Upvotes: 1

Related Questions