jasonc Posted September 19, 2009 Share Posted September 19, 2009 return entiries only if the value of the field is more than '"2009-08-19" i have messed up big time and used the datetime and not the time so all data is stored in GMT and not the unix time stamp format 123456568 there is no chance to change this now so need to be able to return all results that have the GMT data more than today less one month, the last months entries. how can i correctly do this please. Quote Link to comment Share on other sites More sharing options...
gassaz Posted September 21, 2009 Share Posted September 21, 2009 Try this... Select * from Tablename where date_field >= '2009-08-19' and date_field<='2009-09-19' Quote Link to comment Share on other sites More sharing options...
fenway Posted October 2, 2009 Share Posted October 2, 2009 You're storing your dates how? 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.