Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Mon, 17 Jul 2006 @ 21:19:17 GMT

  <Prev Next>   <<First <Prev

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');


  <Prev Next>   <<First <Prev
  Top Home Privacy Feedback  
Copyright for the TeradataForum (TDATA-L), Manta BlueSky    
Copyright 2016 - All Rights Reserved    
Last Modified: 15 Jun 2023