Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: Gunapriyan
- Order by date
-
Convert Date (dd-MM-YYYY) to (dd/MM/YYYY)
Dear Friend, Thanks for your nice reply. It returns like, 02/07/2009 02/07/2010 02/08/2007 02/09/2008 02/09/2008 ----01,02,03 (Only Date) Whole thing must orderna? I expect to return like, 02/08/2007 02/09/2008 02/09/2008 02/07/2009 02/07/2010 ----This is correct. Can you help me? - GUNA- Gunapriyan
- Post #3
- Forum: Microsoft SQL Server: Programming
-
Convert Date (dd-MM-YYYY) to (dd/MM/YYYY)
Dear Sir, In my DB, there is 5000 date values are stored like "DD-MM-YYYY" Format in nvarchar datatype. For Example 18-10-2010 And when i convert into date format for the following purpose. "Select * from tbl_master order by Convert(datetime,date_of_Appln,103)" Its not working. Can you help...- Gunapriyan
- Thread
- Replies: 4
- Forum: Microsoft SQL Server: Programming
