Home Page for the TeradataForum

Archives of the TeradataForum

Message Posted: Wed, 07 May 2003 @ 18:26:57 GMT

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

Subj:   Re: TimeStamp and Coalesce in V2R5
From:   Ganga Palakattil

Execute the following as a SQL statement before issueing the SELECT.


Make sure that the 'I' datatype is Timestamp by using SHOW TABLE command. If not, run the CREATE statement using BTEQ.

You need to say TIMESTAMP and CURRENT_TIMESTAMP straight away instead of suffixing with (6)

-Ganga Palakattil

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