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 conver these SQL to Teradata SQL
Moderators: chulett, rschirm, roy
Pls conver these SQL to Teradata SQL
regards,
Rakesh
Rakesh
-
- Premium Member
- Posts: 197
- Joined: Sun Jul 15, 2007 11:45 pm
- Location: Prague