Converting date format

[sinCity99]

Hi,

I need to convert a date 20091011 to 10/11/2009.

This is how i'm converting it:
convert(varchar,cast(ap.appt_date as dateTime),101) as Date

but my return is 10/11/20

it keeps leaving out the last two numbers of the year.

 

[jsteph]

Change varchar to varchar(10)
--Jim

 

[sinCity99]

yes i did change varchar to varchar(10) but that didn't do anything either.

 

[jsteph]

sin,
For me:

select convert(varchar(10),cast('20091011' as datetime),101)

Returns:
10/11/2009
in sql 2005

 

[markros]

I was trying to figure out what setting or what format to apply to change this (since for me the above code returned 4 digits for year), but didn't find it yet so far.

You can also check this link

http://msdn.microsoft.com/en-us/library/ms180878.aspx#UsingDateandTimeFormats

but quickly browsing through it I could not find the info.

 

[sinCity99]

Thanks for trying to help.

 

[mutley1]

Sin,

Try this

select convert(varchar,(convert (datetime, ap.appt_date)), 101) as 'Date'

HTH,

M