Home Page for the TeradataForum
 

Archives of the TeradataForum

Message Posted: Sun, 21 May 2001 @ 02:01:30 GMT


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


Subj:   Re: Defaults for Date and Time columns
 
From:   David Roth

Without knowing what the 5407 error is, my guess is that your first version of the time format should work with the time(0), but you are probably not specifying the format in which the time is being inserted, something like:

insert into table
values ('a','b',time '14:03:22');

Check the manual for the proper formatting.

Dave

David W. Roth
Senior Consultant
Teradata Solutions Group
Teradata, a Division of NCR



     
  <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: 15 Jun 2023