|
|
|
Junior Member
 
Group: Forum Members
Last Login: Yesterday @ 7:40:45 AM
Posts: 11,
Visits: 40
|
|
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
|
|
|
|
|
Supreme Being
Group: Forum Members
Last Login: Yesterday @ 1:30:56 PM
Posts: 486,
Visits: 216
|
|
Hi Rakesh,
what's the datatype of r_update_date, it can't be datetime, looks like an integer/decimal with julian day within year and that dateadd converts it to a date?
CURRENT_DATE - CAST(CAST(r_update_date AS CHAR(7)) AS DATE FORMAT 'yyyyddd')
Dieter
|
|
|
|
|
Junior Member
Group: Forum Members
Last Login: Yesterday @ 7:40:45 AM
Posts: 11,
Visits: 40
|
|
r_update_date is a CHAR datatype.
Rakesh nc
|
|
|
|