T-SQL to Convert CYYMMDD to Standard Date


  

 --For date between 1900 and 2099
--CYYMMDD
--7 digits
select   Cast(stuff('1170226',1,1,'20') as date) 
-- or
,  Cast(stuff('1170226',1,1
,Case When right('1170226',1)=1 then '20' When right('1170226',1)=0 then '19' End) 
as date) 


 
Advertisements


Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s