Archives of the TeradataForum

Message Posted: Thu, 31 Jul 2003 @ 14:08:54 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

You could join to the Sys_Calendar database... something like this

select Ship_To_Date,
       cast((year_of_calendar (format '9999')) as char(4)) ||
       cast((week_of_year (format '99')) as char(2)) as isodate
       ...
 from yourtable t
    , sys_calendar.calendar c
    ...
 where ship_to_date = calendar_date
   ...

Pat Belle
Certified Master

	<Prev	Next>		<<First	<Prev	Next>	Last>>