Comparing two dates in mysql

Question

I have a mysql database table with a column called task_end_date and task_name.

I want to select all the task_name from the table where the current date has passed task_end_date. How would i do that in mysql using an sql query.

Thanks

karim79 · Accepted Answer · 2009-09-29 09:43:44Z

2

SELECT task_name FROM table WHERE curdate() > task_end_date

Note that curdate() as its name implies has no TIME component. If time really isn't important, then curdate() is the way to go, otherwise go with now().

edited Sep 29, 2009 at 9:43

answered Sep 29, 2009 at 9:38

karim79

343k67 gold badges420 silver badges409 bronze badges

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

Comments

VolkerK · Accepted Answer · 2009-09-29 09:38:02Z

2

SELECT
  x,y,z
FROM
  foo
WHERE
  task_end_date < Now()

Maybe you want Curdate() instead of Now().

answered Sep 29, 2009 at 9:38

VolkerK

96.3k20 gold badges169 silver badges232 bronze badges

Collectives™ on Stack Overflow

Comparing two dates in mysql

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related