Archives of the TeradataForum

Message Posted: Wed, 11 Oct 2000 @ 13:34:35 GMT

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

Using SUBSTRING and concatenating the date and time in the VALUES section also works.

     .LAYOUT INPUTLAYOUT;
           .FIELD DATE_TIME   * CHAR( 19);

     .DML LABEL INSERTS;
     INSERT INTO ACTWCB
           (
            DATE_TIME
      )

     VALUES (
           ,substring(:DATE_TIME from 1 for 10)||' '||substring(:DATE_TIME
     from 12 for 8)
     );

Good Luck.

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