Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 General SQL Server Forums
 New to SQL Server Programming
 basic question - order by date

Author  Topic 

matches
Starting Member

1 Post

Posted - 2010-02-25 : 17:30:08
I have a mySQL DB and I want to order the query results by date. Do the field need to be unix timestamp or can it just be a date field? And what format must the day be in? ie YYYY-MM-DD etc.

Thanks for any help.

RickD
Slow But Sure Yak Herding Master

3608 Posts

Posted - 2010-02-26 : 03:04:51
Probably a question best asked on a MySQL forum, this is a SQL Server forum.
Go to Top of Page

visakh16
Very Important crosS Applying yaK Herder

52326 Posts

Posted - 2010-02-26 : 08:10:01
try your luck at www.dbforums.com

there's a MySQL forum in it

------------------------------------------------------------------------------------------------------
SQL Server MVP
http://visakhm.blogspot.com/

Go to Top of Page

madhivanan
Premature Yak Congratulator

22864 Posts

Posted - 2010-03-01 : 00:59:10
quote:
Originally posted by matches

I have a mySQL DB and I want to order the query results by date. Do the field need to be unix timestamp or can it just be a date field? And what format must the day be in? ie YYYY-MM-DD etc.

Thanks for any help.


If you use front end application, do the formation there

Madhivanan

Failing to plan is Planning to fail
Go to Top of Page
   

- Advertisement -