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. 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 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. 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. 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 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
Archived
This topic is now archived and is closed to further replies.