Archives of the TeradataForum

Message Posted: Mon, 13 Jan 2003 @ 11:56:49 GMT

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

<-- Anonymously Post: Monday, January 13, 2003 05:50 -->

Hi,

I have a Time in CHAR(6), format 'HHMMSS'. Can this be Fastloaded into column defined as TIME(0). If so what FORMAT do i need within the VALUES statement.

Is this the best way to use time fields or use SUBSTRING to manipulate the CHAR(6).

We're running a 2 node 4700 with V2R3 in Teradata mode.

Many thanks

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