Archives of the TeradataForum

Message Posted: Thu, 07 Sep 2006 @ 19:13:12 GMT

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

You might be able to use a variation of this code:

     sel current_date, extract(year from current_date)||
        case
           when extract(month from current_date) < 10  then
     '0'||trim(extract(month from current_date))
           else extract(month from current_date)
        end ||
        case
           when extract(day from current_date) <10 then '0'||trim(extract(day
     from current_date))
           else extract(day from current_date)
        end ;

Fred Keiser

HCIRA - Systems Engineering

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