Converting date to yy.mm.dd format using CONVERT

Jinn · October 14th, 2006, 05:50 PM

I am able to get the date, but I don't know how to convert the date to the yy.mm.dd using CONVERT.

Thanks

SQLScott · October 14th, 2006, 05:57 PM

CONVERT(date, 102)

Look up CAST and CONVERT in the BOL. But the above should give you what you need.

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

SQLScott · October 14th, 2006, 06:01 PM

Sorry, that's:

CONVERT(datetime, date, 102)

For example:

SELECT CONVERT(datetime, GETDATE(), 102)

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html

Jinn · October 14th, 2006, 06:02 PM

I've look up BOL (took me a bit to realize was BOL meant :)) and saw the chart showing 2 or 102 but I can't figure out how to incorporate it with my GETDATE(). What I want to do is convert today's date to yy.mm.dd.

Thanks, Jinn

Jinn · October 14th, 2006, 06:03 PM

:D Thanks :D

Jinn · October 14th, 2006, 06:07 PM

SELECT CONVERT (varchar (15), GETDATE(), 102)

WOOHOO! This is waht I needed. Thank you for pointing me in the right direction!

SQLScott · October 14th, 2006, 06:44 PM

Glad i could help.

Scott Klein
Author - Professional SQL Server 2005 XML
http://www.wrox.com/WileyCDA/WroxTit...764597922.html