otuatail Posted November 19, 2007 Share Posted November 19, 2007 I need to select * from table where date is greater than '01-Nov-2007' Problem is Date is stored as time() stamp. Desmond. Quote Link to comment https://forums.phpfreaks.com/topic/77970-solved-select-dates-from-table/ Share on other sites More sharing options...
otuatail Posted November 19, 2007 Author Share Posted November 19, 2007 Sorted needs this select * from EventLog where Stamp > UNIX_TIMESTAMP('2007-11-14 00:00:00') Desmond Quote Link to comment https://forums.phpfreaks.com/topic/77970-solved-select-dates-from-table/#findComment-394672 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.