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.

 All Forums
 SQL Server 2000 Forums
 Transact-SQL (2000)
 How do I format a date

Author  Topic 

csphard
Posting Yak Master

113 Posts

Posted - 2005-06-07 : 11:53:52
I have a date in the following format.

how do I use sql to format it into MM/DD/YYYY


2004-07-01 00:00:00.000

Seventhnight
Master Smack Fu Yak Hacker

2878 Posts

Posted - 2005-06-07 : 11:56:03
read in BOL on convert(varchar,yourDate,101)

Corey

Secret Service Agent: Mr. President, you're urinating on me.
President Lyndon Johnson: I know I am. It's my prerogative.
Go to Top of Page
   

- Advertisement -