add 28 years aagin

[S G]

HI all,
This has puzzled me all morning. I have a int field which reads
19691124 (UK dates) this is actually a date 24 November 1969 I need to
add 28 years to this making it 19971124 but I’m stumped!
Any ideas anyone?
Cheers
Sean


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

[John Gilson]

"S G" <an*******@devdex.com> wrote in message news:3f*********************@news.frii.net...

HI all,
This has puzzled me all morning. I have a int field which reads
19691124 (UK dates) this is actually a date 24 November 1969 I need to
add 28 years to this making it 19971124 but I'm stumped!
Any ideas anyone?
Cheers
Sean


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If you want a DATETIME returned then

SELECT DATEADD(YEAR, 28, '19691124')

If you want an INT returned then

SELECT CAST(CONVERT(CHAR(8),
DATEADD(YEAR, 28, '19691124'),
112) AS INT)

Regards,
jag

[Albe V°]

S G wrote:

HI all,
This has puzzled me all morning. I have a int field which reads
19691124 (UK dates) this is actually a date 24 November 1969 I need
to add 28 years to this making it 19971124 but I'm stumped!

Select (DateField + 280000) as NewDateField
From Table

By the way, I don't like too much that way of storing dates.

Anyway...

Bye

Alberto

[John Gilson]

Sorry, forgot that your input is an INT. Replace the string '19691124'
with CAST(19691124 AS CHAR(8)).

"John Gilson" <ja*@acm.org> wrote in message news:Rh********************@twister.nyc.rr.com...

"S G" <an*******@devdex.com> wrote in message news:3f*********************@news.frii.net...

HI all,
This has puzzled me all morning. I have a int field which reads
19691124 (UK dates) this is actually a date 24 November 1969 I need to
add 28 years to this making it 19971124 but I'm stumped!
Any ideas anyone?
Cheers
Sean


*** Sent via Developersdex http://www.developersdex.com ***
Don't just participate in USENET...get rewarded for it!

If you want a DATETIME returned then

SELECT DATEADD(YEAR, 28, '19691124')

If you want an INT returned then

SELECT CAST(CONVERT(CHAR(8),
DATEADD(YEAR, 28, '19691124'),
112) AS INT)

Regards,
jag

[John Gilson]

"Albe V°" <va*****************@hotmail.com> wrote in message
news:Iq**********************@twister1.libero.it.. .

S G wrote:

HI all,
This has puzzled me all morning. I have a int field which reads
19691124 (UK dates) this is actually a date 24 November 1969 I need
to add 28 years to this making it 19971124 but I'm stumped!
Select (DateField + 280000) as NewDateField
From Table

This approach will be problematic with a leap year, e.g.,
adding 1 year to 20000229.

Regards,
jag
By the way, I don't like too much that way of storing dates.

Anyway...

Bye

Alberto