How to search date from certain date onwards-CodePudding

Home > Net > How to search date from certain date onwards

How to search date from certain date onwards

Time：01-06

I want to show all dates onward when searching dates. For eg. i searched 2012-12-24, all dates going forward will appear.

Here's my query right now that can search the exact date only and not including date onward.

SELECT * 
FROM user u 
where cast(u.start_date as varchar) = '2012-12-24'

CodePudding user response：

Use an inequality:

SELECT *
FROM user u
WHERE u.start_date >= '2012-12-24';