How to compare date in MySQL query

Databases
1

Hi,

I have

 $date = date("Y-m-d");

How do I get date comparison in MySQL query that looks something like this:


SELECT expired_date
FROM subscription
WHERE expired_date > '$date'

Thanks

2

Hi there,

An easier/cleaner way to do this is as follows:

SELECT expired_date FROM subscription WHERE expired_date > CURRENT_TIMESTAMP;

HTH

3

What Pullo has said above would be better but if you need to convert a string to date in MySQL look at the STR_TO_DATE function.

4

pullo, using CURRENT_DATE instead of CURRENT_TIMESTAMP will more closely match the original requirements here

5

Oops. Right you are! :blush:
Thanks rudy.

6

Thanks,

I knew I can rely on your guys here. :slight_smile: