Home Page for the TeradataForum
 

Archives of the TeradataForum

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


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


Subj:   Info regarding teradata function
 
From:   gagan.bharadia

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>>  
 
 
 
 
 
 
 
 
  
  Top Home Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 27 Dec 2016