How to compare date in MySQL query

**ketting00** · Nov 3, 2012 22:12

Hi,

I have

Code:

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

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

Code:

SELECT expired_date
FROM subscription
WHERE expired_date > '$date'

Thanks

**Pullo** · Nov 4, 2012 02:37

Hi there,

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

Code MySQL:

SELECT expired_date FROM subscription WHERE expired_date > CURRENT_TIMESTAMP;

HTH

**rcashell** · Nov 4, 2012 04:11

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.

**r937** · Nov 4, 2012 07:33

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

**Pullo** · Nov 4, 2012 07:34

Originally Posted by r937

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

Oops. Right you are!

Thanks rudy.

**ketting00** · Nov 4, 2012 20:03

Thanks,

I knew I can rely on your guys here.

User Tag List