Archives of the TeradataForum

Message Posted: Mon, 22 Aug 2005 @ 19:01:04 GMT

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

I've never had an issue using this:

     select case (date - date '1900-01-01') mod 7
                 when 0 then 'Monday'
                 when 1 then 'Tuesday'
                 when 2 then 'Wednesday'
                 when 3 then 'Thursday'
                 when 4 then 'Friday'
                 when 5 then 'Saturday'
                 when 6 then 'Sunday'
                 end as DAY_OF_WEEK;

Wayne Schachtel
Wayne Schachtel Consulting

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