Use datetime to find age?
Posted: Thu Apr 01, 2010 7:10 pm
I want to find out how "fresh" an entry is, selecting only entries added 30 days from the current date.
I have a column called imagedate and the values are stored as datetime ( 0000-00-00 00:00:00 ). How could I write a query that will choose entries that are no older than 30 days?
Thanks for your help!
I have a column called imagedate and the values are stored as datetime ( 0000-00-00 00:00:00 ). How could I write a query that will choose entries that are no older than 30 days?
Thanks for your help!