Home Page for the TeradataForum
 
 

 

Archives of the TeradataForum





Message Posted: Thu, 17 May 2001 @ 12:36:07 GMT





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




Subj:   Defaults for Date and Time columns
 
From:   Anomy Anom



<-- Anonymously Posted: Wednesday, May 16, 2001 15:07 -->

I have a need to create a table that will have a CREATE_DATE column and a CREATE_TIME column. I would like to set up these columns to default to current date and current time, without having to be explicitly supplied at insert time. Any help would be appreciated!





     
  <Prev Next>  
<<First
<Prev
Next> Last>>  
 
 
 
 
 
 
 
 
  
 
  Top Home Join Privacy Feedback  
 
 
Copyright for the TeradataForum (TDATA-L), Manta BlueSky 
Last Modified: 30 Jun 2008