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 |
|
raahsalah
Starting Member
1 Post |
 Posted - 2011-04-08 : 11:22:44
|
| Dear All,When I want to sort my table order by date then its only sorted using date value and always ignore month and year. This date i insert using javascript calendar and format is 1-Jan-2011.Please help as soon.Regards,raahsalahRaahsalah SalakASP.NET,PHP and SQL Server 2008 Programmer |
|
|
sunitabeck
Master Smack Fu Yak Hacker
5155 Posts |
Posted - 2011-04-08 : 12:01:35
|
What I suspect is that you are inserting the data into a column that is not a date type (datetime, smalldatetime), or sorting one. Most likely a string type of column such as varchar may be what you are using. You might try sorting it after casting to one of those types as incast (YourDate as datetime) |
 |
|
|
|
|
|
Javascript date did not sorted properly using SQL