Pls conver these SQL to Teradata SQL
Posted: Sat Feb 02, 2008 4:33 am
hi,
pls convert the following SQL queries to Teradata SQL.
1.
DATEDIFF(day,dateadd ( dd , ( r_update_date % 1000 ) - 1 , convert ( datetime ,convert( char(4) , r_update_date / 1000 ) + '/01/01') ) , GETDATE()) > 90[/b][/i]
2.
datepart(d,dateadd(day,-datepart(d,getdate()),getdate());
Rakesh nc
pls convert the following SQL queries to Teradata SQL.
1.
DATEDIFF(day,dateadd ( dd , ( r_update_date % 1000 ) - 1 , convert ( datetime ,convert( char(4) , r_update_date / 1000 ) + '/01/01') ) , GETDATE()) > 90[/b][/i]
2.
datepart(d,dateadd(day,-datepart(d,getdate()),getdate());
Rakesh nc