Date in the past

[NLCJ]

Hello,

I've got some SQL queries and in a row in the table is a date. Formatted: dd-mm-yyyy. Now I have to check if that date is in the past, so how should i do it? Using '<' doesn't work and Google ain't helping a lot...

 

Regards,

Chris

[Mchl]

Using '<' doesn't work

 

That's because you're storing your date in VARCHAR() or similar datatype, instead of proper DATE. Fix this and it'll work.

[kenrbnsn]

When using dates in MySQL, you should store them in columns as a DATE type, which is formatted as YYYY-MM-DD, then date comparisons will work fine.

 

You can display them any way you want.

 

Ken

[NLCJ]

But if I insert them using YYYY-MM-DD, how can I display them then like: DD-MM-YYYY?

[Pikachu2000]

SELECT DATE_FORMAT(`field`, '[format parameters]') AS date

[NLCJ]

SELECT DATE_FORMAT(`field`, '[format parameters]') AS date

 

I don't need it directly in the SQL query, I just need PHP to check it (using if and else). I've found a function using reformat_date, maybe this will work?

[NLCJ]

I've fixed it using reformat_date. Thanks for your suggestions though!