Convert to mm/dd/yyyy

Question

Post reply

Convert to mm/dd/yyyy

PSB

SSChampion

Points: 13195
More actions
February 1, 2011 at 5:45 pm

#233710

Hi,
I have a table with DOB in the format Sep 27 1957 12:00AM
I need to convert it into 09/27/1957
Please help.

Viewing 8 posts - 1 through 7 (of 7 total)

You must be logged in to reply to this topic. Login to reply

Evil Kraig F SSC Guru Points: 100851 More actions · Answer 1

Use BOL and look up the available formats to the CONVERT function.

- Craig Farrell

Never stop learning, even if it hurts. Ego bruises are practically mandatory as you learn unless you've never risked enough to make a mistake.

For better assistance in answering your questions[/url] | Forum Netiquette
For index/tuning help, follow these directions.[/url] |Tally Tables[/url]
Twitter: @AnyWayDBA

PSB SSChampion Points: 13195 More actions · Answer 2

PSB

SSChampion

Points: 13195

February 1, 2011 at 5:59 pm

#1281208

CAn you give an example ?

Ron McCullough SSC Guru Points: 63877 More actions · Answer 3

PSB (2/1/2011)
CAn you give an example ?

Go here :

http://technet.microsoft.com/en-us/library/ms187928(SQL.90).aspx

If everything seems to be going well, you have obviously overlooked something.

Ron

Please help us, help you -before posting a question please read[/url]
Before posting a performance problem please read[/url]

VSSGeorge SSCrazy Eights Points: 8151 More actions · Answer 4

Hi

Just refer this link

http://www.mssqltips.com/tip.asp?tip=1145

TheSQLGuru SSC Guru Points: 134017 More actions · Answer 5

CAST and CONVERT in books online. There are many examples there.

Best,
Kevin G. Boles
SQL Server Consultant
SQL MVP 2007-2012
TheSQLGuru on googles mail service

Chris Hurlbut SSCarpal Tunnel Points: 4162 More actions · Answer 6

Well here you go:

select Convert(VarChar, GETDATE(), 101)

rVadim Hall of Fame Points: 3969 More actions · Answer 7

SELECT CONVERT(CHAR(10), CONVERT(DATETIME, 'Sep 27 1957 12:00AM', 109), 101)

--Vadim R.