Hi All -
i am having trouble to insert the 2010-1-10.21.5.59.951939000 value into a time stamp field which is defined as TIMESTAMP(6) FORMAT 'YYYYMMDDBHH:MI:SS.S(F)'.
Could you please provide me a solution how to insert this into TIMESTAMP(6) FORMAT 'YYYYMMDDBHH:MI:SS.S(F)'.
Thank you very much
in TD14 you can utilize Oracle's TO_TIMESTAMP:
But both Teradata and Oracle don't support a single digit month, so you need to add the missing zero:
TO_TIMESTAMP(CASE WHEN x LIKE '____-_-%' THEN SUBSTRING(x FROM 1 FOR 5) || '0' || SUBSTRING(x FROM 6)