Archives of the TeradataForum

Message Posted: Tue, 04 May 2010 @ 15:02:32 GMT

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

I think you need a space between the Date and time ...

            ,TIMESTMP_PLOG_GMT                =
     CAST((SUBSTR(:TIMESTMP_PLOG_GMT,1,4)
     || '-' || SUBSTR(:TIMESTMP_PLOG_GMT,5,2)
     || '-' || SUBSTR(:TIMESTMP_PLOG_GMT,7,2)
     || ' ' || SUBSTR(:TIMESTMP_PLOG_GMT,10,2)        ----> Space
     || ':' || SUBSTR(:TIMESTMP_PLOG_GMT,12,2)
     || ':' || SUBSTR(:TIMESTMP_PLOG_GMT,14,2)
         )  AS TIMESTAMP(0))

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