How can i format a datetime column to a specific date format? (T-SQL)

Page 1 of 1

1 Replies - 787 Views - Last Post: 07 December 2011 - 11:38 AM

#1 CyberSlayer  Icon User is offline

  • New D.I.C Head

Reputation: 0
  • View blog
  • Posts: 10
  • Joined: 31-October 11

How can i format a datetime column to a specific date format? (T-SQL)

Posted 07 December 2011 - 09:57 AM

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?
Is This A Good Question/Topic? 0
  • +

Replies To: How can i format a datetime column to a specific date format? (T-SQL)

#2 eclipsed4utoo  Icon User is offline

  • Not Your Ordinary Programmer
  • member icon

Reputation: 1532
  • View blog
  • Posts: 5,969
  • Joined: 21-March 08

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.
Was This Post Helpful? 0
  • +
  • -
Page 1 of 1