It's currently outputting like this: 1998-06-01 00:00:00.000.
I just want it to output like: 06/01/1998 or Month/Day/Year
How would I do this in T-SQL?
1 Replies - 851 Views - Last Post: 07 December 2011 - 11:38 AM
#1
How can i format a datetime column to a specific date format? (T-SQL)
Posted 07 December 2011 - 09:57 AM
Replies To: How can i format a datetime column to a specific date format? (T-SQL)
#2
Re: How can i format a datetime column to a specific date format? (T-SQL)
Posted 07 December 2011 - 11:38 AM
There are about 21 different ways to format a date in SQL Server. Here is a link.
http://msdn.microsof...y/ms187928.aspx
Looks like you want 101 from that list.
http://msdn.microsof...y/ms187928.aspx
Looks like you want 101 from that list.
Page 1 of 1