Use systimestamp in insert statement : SYSTIMESTAMP « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. SYSTIMESTAMP

Use systimestamp in insert statement

  
SQL> create table tstz
  2  (c1 timestamp with time zone,
  3   c2 timestamp with time zone,
  4   c3 timestamp with time zone);

Table created.

SQL>
SQL>
SQL> insert into tstz (c1,c2,c3)values( systimestamp   ,systimestamp   ,systimestamp);

1 row created.

SQL>
SQL> select * from tstz;
C1
---------------------------------------------------------------------------
C2
---------------------------------------------------------------------------
C3
---------------------------------------------------------------------------
16-JUN-08 05.40.39.576000 PM -07:00
16-JUN-08 05.40.39.576000 PM -07:00
16-JUN-08 05.40.39.576000 PM -07:00


1 row selected.

SQL>
SQL> drop table tstz;

Table dropped.

SQL> --








Related examples in the same category

1.Get the SYSTIMESTAMP
2.Display the sessions current time/timezone AND the Operating systems time/timezone in PL/SQL code block
3.Using systimestamp to do benchmark