Mega Code Archive
INSERT statement adds a row with the TIMESTAMP keyword to supply a datetime literals
<![CDATA[
SQL>
SQL> -- INSERT statement adds a row with the TIMESTAMP keyword to supply a datetime literals
SQL>
SQL> CREATE TABLE purchases_with_timestamp (
2 product_id INTEGER,
3 customer_id INTEGER,
4 made_on TIMESTAMP(4)
5 );
Table created.
SQL>
SQL>
SQL> INSERT INTO purchases_with_timestamp ( product_id, customer_id, made_on )
2 VALUES ( 1, 1, TIMESTAMP '2005-05-13 07:15:31.1234');
1 row created.
SQL>
SQL> select * from purchases_with_timestamp;
PRODUCT_ID CUSTOMER_ID MADE_ON
---------- ----------- ---------------------------------------------------------------------------
1 1 13-MAY-05 07.15.31.1234 AM
SQL>
SQL> drop table purchases_with_timestamp;
Table dropped.
SQL>
SQL>
]]>