cgm225 Posted March 17, 2008 Share Posted March 17, 2008 I have a MySQL table with entries/rows with a TIMESTAMP column that contains date and time information in the following format, for example: 2008-03-16 22:27:03 I want to create a MySQL query that will return all entries with a timestamp from within the last thirty days. Any ideas? Thank you all in advance! Quote Link to comment Share on other sites More sharing options...
teng84 Posted March 17, 2008 Share Posted March 17, 2008 you can try select fields from table where datediff(now(),youredatehere)>=30 Quote Link to comment Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.