Jump to content


Photo

Order By Dates?


  • Please log in to reply
2 replies to this topic

#1 garethppls

garethppls
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 28 June 2006 - 03:23 PM

how to order data via dates in MYSQL please?

#2 AndyB

AndyB
  • Staff Alumni
  • Advanced Member
  • 5,465 posts
  • LocationToronto

Posted 28 June 2006 - 05:19 PM

[!--sql--][div class=\'sqltop\']SQL[/div][div class=\'sqlmain\'][!--sql1--][span style=\'color:blue;font-weight:bold\']SELECT[/span] something FROM some_table ORDER BY date_fieldname .... [!--sql2--][/div][!--sql3--]
Legend has it that reading the manual never killed anyone.
My site

#3 garethppls

garethppls
  • New Members
  • Pip
  • Newbie
  • 8 posts

Posted 29 June 2006 - 08:02 AM

[!--quoteo(post=388910:date=Jun 28 2006, 06:19 PM:name=AndyB)--][div class=\'quotetop\']QUOTE(AndyB @ Jun 28 2006, 06:19 PM) View Post[/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 FROM some_table ORDER BY 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!!*




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users