InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comWed, 03 Dec 2008 19:47:29 GMT20http://www.teradata.com/teradataforum/Topic10483-1-1.aspxr_update_date is a CHAR datatype.Mon, 04 Feb 2008 01:58:40 GMTRakesh nchttp://www.teradata.com/teradataforum/Topic10483-1-1.aspxHi 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')DieterSat, 02 Feb 2008 09:30:24 GMTdnoethhttp://www.teradata.com/teradataforum/Topic10483-1-1.aspxhi,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());Sat, 02 Feb 2008 05:26:18 GMTRakesh nc