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.
| Author |
Topic |
|
Easwar
Yak Posting Veteran
59 Posts |
 Posted - 2007-10-30 : 06:49:41
|
| Hi i need one queryExample table1--------------Date==>Field type is string not datetime-----3 November, 200710 November, 20072 December, 20073 November, 200711 November, 20071 December, 20071 November, 20077 November, 2007--------------------i need result is-------------------1 December, 20072 December, 20071 November, 20073 November, 20073 November, 20077 November, 200710 November, 200711 November, 2007----------------------How any query |
|
|
Kristen
Test
22859 Posts |
Posted - 2007-10-30 : 07:56:41
|
| Don't store dates as string, store them as DATETIME datatype, then the problem goes away!!!Use CONVERT to convert from String to Datetime.Kristen |
 |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2007-10-30 : 08:29:30
|
Don't store Formatted dates as string, store them in proper DATETIME datatype and let the front end do the formation  .Useselect.....Order by cast(col as datetime) descMadhivananFailing to plan is Planning to fail |
|
|
|
SwePeso
Patron Saint of Lost Yaks
30421 Posts |
Posted - 2007-10-30 : 13:44:24
|
Look closely to the ordering. It is not straight order by...ORDER BY YEAR(CAST(Date AS DATETIME)) DESC, MONTH(CAST(Date AS DATETIME)) DESC, DAY(CAST(Date AS DATETIME))
E 12°55'05.25"N 56°04'39.16" |
|
|
|
|
|
|
|
|
Order By