Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Tue, 14 Aug 2007 @ 16:50:49 GMT

  <Prev Next>  
Next> Last>>  

Subj:   CASTing to lesser precision
From:   Anomy Anom

<-- Anonymously Posted: Tuesday, August 14, 2007 06:44 -->


I like to cast a timstamp field to the lesser precision, the manual says, its not allowed.

Is there a workaround for it, or how is it been done in real time, when its required.

For example, the below query gives the error

     "7454:  DateTime field overflow "

     sel cast(current_timestamp(6) as timestamp(0));

Please throw some light, if you have come across this problem before.

Thanks much

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