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