 |
 |
Archives of the TeradataForum
Message Posted: Mon, 17 Jul 2006 @ 21:19:17 GMT
| Subj: | | Re: 3527 error - Format string 'YYYYMMDDHHMISS' has combination of numeric, character and GRAPHIC values |
| |
| From: | | Dieter Noeth |
Vivek Pandey wrote:
| | Any idea regarding the below error. I am not able to follow the vocabulary what Teradata manual gives about this one. | |
Hi Vivek,
there are no more automatic typecasts for Timestamp/Time/Interval, you have to do it explicitly:
UPDATE ts2
Set a = NULLIF( '20060717121212', ' ' )(timestamp(0), FORMAT 'YYYYMMDDHHMISS');
Dieter
| |
