date manipulation function

[vadimg]

hi.
i have a string date: '19981231'
i need to get a date that's 1 year back from this date.

what function would i use to convert this string into datetime and then minus 1 year from it?

thanks!

 

[vadimg]

ok, i actually decided not to be lazy and look up the syntax myself.

i have

add_months(to_date(char_field, 'yyyymmdd'),-12)

is there something specifically for years, or should i just use months?

 

[carp]

I would use months - you code looks fine the way it is.

Elbert, CO
1359 MDT