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. 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. 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 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 .... Link to comment https://forums.phpfreaks.com/topic/4817-order-by-datetime/#findComment-16955 Share on other sites More sharing options...
Recommended Posts
Archived
This topic is now archived and is closed to further replies.