Use to_date in insert statement : TO_DATE « Date Timezone « Oracle PL / SQL






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

Use to_date in insert statement

   
SQL>
SQL>
SQL>  create table author_log(
  2      activity clob,
  3      completed date
  4    )
  5    /

Table created.

SQL>
SQL>
SQL>  insert into author_log values (
  2      'Began SQL Functions appendix',
  3      to_date( '04-NOV-2001 08:00', 'DD-MON-YYYY HH24:MI' )
  4    )
  5    /

1 row created.

SQL>
SQL> select * from author_log;
ACTIVITY                                                                         COMPLETED
-------------------------------------------------------------------------------- ---------
Began SQL Functions appendix                                                     04-NOV-01

1 row selected.

SQL>
SQL> drop table author_log;

Table dropped.

SQL>
SQL> --








Related examples in the same category

1.TO_CHAR(ADD_MON(TO_DATE('29-FEB-2000','DD-MON-YYYY'),1),'DD-MON-YYYY')
2.Using TO_DATE Within PL/SQL
3.to_date() and insert statement
4.Combine to_char, add_months and to_date function