Archives of the TeradataForum

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

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

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>>