Date Functions
Posted: Thu Mar 04, 2004 10:56 am
Morning Happy Campers,
I am trying to see if a date in my date column will happen within the next 30.60.90 days.
When I use.
I seem to get results of dates that are not set ( ie... 0000-00-00) but no matter what I set the + number to I always get the same results.
Any one have an idea of how to get the results of days that will expire in the future??
Regards
I am trying to see if a date in my date column will happen within the next 30.60.90 days.
When I use.
Code: Select all
select * from domains where expire <= (now() + 30)Any one have an idea of how to get the results of days that will expire in the future??
Regards