Mega Code Archive

 

Categories / Oracle PLSQL / Date Timezone

 

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> --