Dane
I RPG it's %date(mydt80:*iso0)
but I don't think that SQL has an ISO0
so it's
Date(substr(char(mydt90).1.4) || '-'||
substr(char(mydt90).5.2) || '-'||
substr(char(mydt90).7.2) , ISO)

Phil

-------------- kccrosser

Cast and Convert allow converting to/from datetime and strings easily, and supports multiple different ISO and non-ISO formats.

Convert(datetime, <inputvar>, 114) will convert a string of the form ccyymmdd to a datetime value.

SQL Books Online has all the codes used to convert back and forth.

Then, once you have two dates, the months between them is easily obtained with DateDiff and GetDate:

declare @datestring varchar(8)
declare @datethen datetime
declare @monthssince int
...
set @datestring = '20060724'
set @datethen = convert(datetime, @datestring, 114)
set @monthssince = datediff(m, @datethen, getdate())

--------------------------------
Sorry, finally got to test this.
Had a couple of periods and didn't need ISO

Date(substr(char(mydt80),1,4) || '-'||
substr(char(mydt80),5,2) || '-'||
substr(char(mydt80),7,2) )

Select Fld1, Fld2,
Date(substr(char(mydt80),1,4) || '-'||
substr(char(mydt80),5,2) || '-'||
substr(char(mydt80),7,2) )

from myfile

Phil

Please complete the following information:

REGISTER / LOG-IN TO DISCUSS

- - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - -

Submit your e-mail address below to continue

E-mail: 

E-mail: 

Handle:   

Password: 

Forgot Password?

Create Handle: 

Your handle identifies you in ITKnowledgeExchange. Max 30 char.

Create Password: 

Confirm Password: 

Yes, I agree to the IT Knowledge Exchange  Terms and Conditions.

hidden modal window