1.11M Members

how to check expiration date in mysql

 
0
 

hi.

i want to check expire date with mysql query between start date and enddate.

if the end date is bigger then today's date then its good else it didnt display records.


can any one please help me out.


Thanks in advance. :)

 
0
 

if any one know plase help me out.

Thanks.

 
0
 

How about using this condition ?
(EnDate<now())

This is what use myself and it works fine.

 
0
 

Don't think this question is for javascript??? Or you are talking about attempting to do the comparison of dates obtained by mysql on a HTML page?

 
0
 

select * from table name where account_expiry < now();
try this it is working fine.

You
This article has been dead for over six months: Start a new discussion instead
Post:
Start New Discussion
View similar articles that have also been tagged: