InstantForum.NET v4.1.4Teradata Forumshttp://www.teradata.com/teradataforum/info@teradata.comSat, 06 Sep 2008 22:42:32 GMT20http://www.teradata.com/teradataforum/Topic9495-22-1.aspxLaxmi,Maybe the following structure helps you:create table test (id INTEGER);INSERT TEST VALUES (2007090909);INSERT TEST VALUES (2007110914);SELECT CAST((CAST (ID AS CHAR(10))) AS TIMESTAMP FORMAT 'YYYYMMDDHH')FROM TEST;Good luck!Fri, 09 Nov 2007 11:48:12 GMTFabiohttp://www.teradata.com/teradataforum/Topic9495-22-1.aspxHi Laxmi,providing the actual error is more helpful than just "doesn't work".And why do you cast cal_id to an integer if it's already an integer?DieterTue, 30 Oct 2007 05:39:47 GMTdnoethhttp://www.teradata.com/teradataforum/Topic9495-22-1.aspxHere is the query i am trying to run :select cast(cast(cast(cal.cal_id as integer format '9999999999') as varchar(10) ) as timestamp(0) format 'YYYYMMDDHH') from miesa01.calen cal Here cal_id is an integer column.. i have tried all the variations for this .. the strange part is the following query works perfectly fineselect cast(cast(cast(2007090909 as integer format '9999999999') as varchar(10) ) as timestamp(0) format 'YYYYMMDDHH') from miesa01.D_CAL_CALENDAR cal Please try to pur your ideas and experience. Thanks,LaxmiMon, 29 Oct 2007 19:14:38 GMTtera_cert