essjay_d12 Posted March 13, 2006 Share Posted March 13, 2006 I need to order the table results by the Date and if its the same Date then the most recent time.There is a DATETIME function , but I was wondering is it possible to get the System Date and time and insert it some how (Rather than the user inserting it).If not what would be the best way of solving this?ThanksD. Quote Link to comment https://forums.phpfreaks.com/topic/4817-order-by-datetime/ Share on other sites More sharing options...
webwiese Posted March 13, 2006 Share Posted March 13, 2006 Hi,just use the SQL - DATETIME field. Quote Link to comment https://forums.phpfreaks.com/topic/4817-order-by-datetime/#findComment-16941 Share on other sites More sharing options...
essjay_d12 Posted March 13, 2006 Author Share Posted March 13, 2006 Yeah I have done that, but I wanted a syste, date ...I found it ... using NOW() seems to insert the current date and time of the system.ThanksD Quote Link to comment https://forums.phpfreaks.com/topic/4817-order-by-datetime/#findComment-16954 Share on other sites More sharing options...
webwiese Posted March 13, 2006 Share Posted March 13, 2006 oh, I'm sorry, I've read your article too fast .... Quote Link to comment https://forums.phpfreaks.com/topic/4817-order-by-datetime/#findComment-16955 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.