![](//teradataforum.com/imgs/ptdfw1.gif) |
![](//teradataforum.com/imgs/ptdfw2.gif) |
Archives of the TeradataForum
Message Posted: Wed, 19 Oct 2011 @ 09:10:24 GMT
Subj: | | Re: Insert CHAR to TIMESTAMP |
|
From: | | R, Murali |
Here is the output:
BTEQ -- Enter your SQL request or BTEQ command:
CREATE TABLE TABLE_TIMESTAMP( EMP_IN_TIME TIMESTAMP(0));
CREATE TABLE TABLE_TIMESTAMP( EMP_IN_TIME TIMESTAMP(0));
*** Table has been created.
*** Total elapsed time was 1 second.
BTEQ -- Enter your SQL request or BTEQ command:
INSERT INTO TABLE_TIMESTAMP('2011-09-23 15:29:59');
INSERT INTO TABLE_TIMESTAMP('2011-09-23 15:29:59');
*** Insert completed. One row added.
*** Total elapsed time was 1 second.
BTEQ -- Enter your SQL request or BTEQ command:
sel * from TABLE_TIMESTAMP;
sel * from TABLE_TIMESTAMP;
*** Query completed. One row found. One column returned.
*** Total elapsed time was 1 second.
EMP_IN_TIME
--------------------------
2011-09-23 15:29:59.000000
Let me know if u need more info.
Regards
Murali R
| |