Archives of the TeradataForum

Message Posted: Wed, 19 Oct 2011 @ 12:35:08 GMT

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

      BTEQ -- Enter your SQL request or BTEQ command:
     ct time_stamp1(emp TIMESTAMP(0) FORMAT 'YYYYMMDDBHHMISS');

     ct time_stamp1(emp TIMESTAMP(0) FORMAT 'YYYYMMDDBHHMISS');

      *** Table has been created.
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your SQL request or BTEQ command:
     insert into time_stamp1('20111019 053854');

     insert into time_stamp1('20111019 053854');

      *** Insert completed. One row added.
      *** Total elapsed time was 1 second.


      BTEQ -- Enter your SQL request or BTEQ command:
     sel * from time_stamp1;

     sel * from time_stamp1;

      *** Query completed. One row found. One column returned.
      *** Total elapsed time was 1 second.

                 emp
     ---------------
     20111019 053854

Thanks & Regards

Murali R

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