otuatail Posted November 5, 2009 Share Posted November 5, 2009 Hi I want to do a query like Where date is > than '12-10-2009 12:22:21' This is an english date format. US use MM-DD-YYYY. The database is YYYY-MM-DD HH:MM:SS Is there a function that takes care of the diffent date formats for this, or would I need to role my own? Desmond. Quote Link to comment https://forums.phpfreaks.com/topic/180477-solved-date-format-is-than/ Share on other sites More sharing options...
Mchl Posted November 5, 2009 Share Posted November 5, 2009 All (pretty much) you need to toy with date and time http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html Quote Link to comment https://forums.phpfreaks.com/topic/180477-solved-date-format-is-than/#findComment-952117 Share on other sites More sharing options...
otuatail Posted November 5, 2009 Author Share Posted November 5, 2009 Ok thanks i thought so. .NET has a masive function for this. I will now sit down in a dark room and re-invent a wheel. Will let you know the results. Desmond. Quote Link to comment https://forums.phpfreaks.com/topic/180477-solved-date-format-is-than/#findComment-952123 Share on other sites More sharing options...
otuatail Posted November 5, 2009 Author Share Posted November 5, 2009 Quick Q how do I get this news group to send emails of problems. I on on AOL so no outlook / outlook express. Desmond. Quote Link to comment https://forums.phpfreaks.com/topic/180477-solved-date-format-is-than/#findComment-952128 Share on other sites More sharing options...
Mchl Posted November 5, 2009 Share Posted November 5, 2009 Ok thanks i thought so. .NET has a masive function for this. I will now sit down in a dark room and re-invent a wheel. Will let you know the results. Desmond. So does MySQL: http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_sec-to-time Quote Link to comment https://forums.phpfreaks.com/topic/180477-solved-date-format-is-than/#findComment-952142 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.