TalkPHP - View Single Post

nefus · 06-19-2009, 06:49 PM

So I'm wondering about order by date but I guess this probably covers most order by questions. If you do something like

Code:

 Select * from events ORDER BY date_field

Is it best to use yyyy/mm/dd or can you use dd/mm/yyyy. I assume it'll go left to right in the field and the year/month/day is the best way to sort?

06-19-2009, 06:49 PM	#1 (permalink)
nefus The Contributor Join Date: Nov 2007 Location: Nashville, TN Posts: 66 Thanks: 20	mysql order by date So I'm wondering about order by date but I guess this probably covers most order by questions. If you do something like Code: Select * from events ORDER BY date_field Is it best to use yyyy/mm/dd or can you use dd/mm/yyyy. I assume it'll go left to right in the field and the year/month/day is the best way to sort? __________________ I am not a programmer, nor do I play one on tv.