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.


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: 28 Jun 2020