garethppls Posted June 28, 2006 Share Posted June 28, 2006 how to order data via dates in MYSQL please? Quote Link to comment https://forums.phpfreaks.com/topic/13117-order-by-dates/ Share on other sites More sharing options...
AndyB Posted June 28, 2006 Share Posted June 28, 2006 [!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] something [color=green]FROM[/color] [color=orange]some_table[/color] [color=green]ORDER BY[/color] date_fieldname .... [!--sql2--][/div][!--sql3--] Quote Link to comment https://forums.phpfreaks.com/topic/13117-order-by-dates/#findComment-50482 Share on other sites More sharing options...
garethppls Posted June 29, 2006 Author Share Posted June 29, 2006 [!--quoteo(post=388910:date=Jun 28 2006, 06:19 PM:name=AndyB)--][div class=\'quotetop\']QUOTE(AndyB @ Jun 28 2006, 06:19 PM) [snapback]388910[/snapback][/div][div class=\'quotemain\'][!--quotec--][!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] something [color=green]FROM[/color] [color=orange]some_table[/color] [color=green]ORDER BY[/color] date_fieldname .... [!--sql2--][/div][!--sql3--][/quote]how would someone put the date in the correct format for MYSQL[a href=\"http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html\" target=\"_blank\"]http://dev.mysql.com/doc/refman/5.0/en/timestamp-4-1.html[/a]*edit: found it here thanks!!* Quote Link to comment https://forums.phpfreaks.com/topic/13117-order-by-dates/#findComment-50725 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.