Pls conver these SQL to Teradata SQL

rakesh.nc · Post by **rakesh.nc** » 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

DS_FocusGroup · Post by **DS_FocusGroup** » Sat Feb 02, 2008 5:37 am

what do u want to do ?

chulett · Post by **chulett** » Sat Feb 02, 2008 8:24 am

No thank you. Surely there is someone you work with that could help you with that.