Convert Integer to Date 1

[R7Dave]

Heelo

Is it possible to convert an integer to a date when my data looks like this

60,712

and is supposed to mean...

07/12/06

Is it possible to use CAST or CONVERT to detect this? Is it possible to assign a style? If so, how?

Thanks
Dave

 

[SkipVought]

Hi,

I think that your 'number' ought to be a 6-character string: yymmdd in CONVERT

Skip,

_{Just traded in my old subtlety...
for a NUANCE!}

 

[markros]

something like

select cast('200'+cast(myInteger as varchar(5)) as datetime)

 

[bborissov]

I'm curious how the dates from previous century are presented?

Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[R7Dave]

Hello all

Previous Century Example = 910824

I have this working so far...

cast(right('0'+cast(MOrigIncep as varchar(6)),6) as datetime) as 'Inception Date',

which gives me

2006-07-12 00:00:00.000

does anybody know what I can add to make it...

07/12/06


I know I'm close, thanks for the help

Dave

 

[R7Dave]

Hello - I was able to get it - Thanks again

convert(varchar, cast(right('0'+cast(MOrigIncep as varchar(6)),6) as datetime),101) as 'Inception Date'

Displays

12/07/2006


...still looking for 2 digit year

Thanks
Dave

 

[markros]

See

http://wiki.lessthandot.com/index.php/Formatting_Dates

 

[R7Dave]

Thank you markos - I went to 50 sites and thats the first one Ive seen with mm/dd/yy (everything but)

convert(varchar, cast(right('0'+cast(MOrigIncep as varchar(6)),6) as datetime),1) as 'Inception Date',

Thanks again

 

[bborissov]

Hmmm,
There is "Thank markros for this valuable post!" link below markros post


Borislav Borissov
VFP9 SP2, SQL Server 2000/2005.

 

[markros]

You're welcome, I discovered this page just few days ago myself.