Archives of the TeradataForum

Message Posted: Tue, 26 Feb 2008 @ 12:48:57 GMT

	<Prev	Next>		<<First	<Prev	Next>	Last>>

Can you please give me the equivalent code in Teradata for the below oracle code

     TO_CHAR(TO_DATE(LPAD(DECODE(DELNMAST_PREVD6,0,010100,
     DELNMAST_PREVD6),6,0),'DDMMYY'), 'YYYY-MM-DD HH24:MI:SS'),

Regards,

Lava Kumar

	<Prev	Next>		<<First	<Prev	Next>	Last>>