Archives of the TeradataForum

Message Posted: Tue, 23 Nov 2004 @ 18:43:48 GMT

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

<-- Anonymously Posted: Tuesday, November 23, 2004 13:02 -->

In V2R5 or later, CAST(:Char6Field as TIME(0) FORMAT 'HHMISS') in the INSERT should work.

On older versions, define 3 CHAR(2) fields and use MLOAD field expression capability to insert the ":" delimiters.

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