Archives of the TeradataForum

Message Posted: Thu, 28 Feb 2008 @ 08:42:17 GMT

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

Hi,

Could anyone tell me how to implement Next_dat()(in oracle) into teradata.

Also,for

     TO_CHAR(TO_DATE(value, 'DDMMYYYY'), 'D'),

is that equivalent teradata statement is correct

     (case when (current_date - date '1900-01-01') mod 7 = 0 then '1'
       when (current_date - date '1900-01-01') mod 7 = 1 then '2'
       when (current_date - date '1900-01-01') mod 7 = 2 then '3'
       when (current_date - date '1900-01-01') mod 7 = 3 then '4'
       when (current_date - date '1900-01-01') mod 7 = 4 then '5'
       when (current_date - date '1900-01-01') mod 7 = 5 then '6'
       when (current_date - date '1900-01-01') mod 7 = 6 then '7'
       end )

If no,than guide me to sort out this.

Thanks in advance for your coming suggestions.

Thanks & Regards

Gagan

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