Birthday before 1940 : TO_DATE « Date Timestamp Functions « Oracle PL/SQL Tutorial






  1. Oracle PL/SQL Tutorial
  2. Date Timestamp Functions
  3. TO_DATE
SQL>
SQL>
SQL>
SQL> CREATE TABLE employee (
  2  id          number,
  3  name        varchar(100),
  4  birth_date  date,
  5  gender      varchar2(30) );

Table created.

SQL>
SQL> INSERT INTO employee (id,name,birth_date,gender )VALUES (100,'J',to_date('19230823', 'YYYYMMDD'),'MALE' );

1 row created.

SQL>
SQL> SELECT name
  2  FROM   employee
  3  WHERE  birth_date < to_date('19400101', 'YYYYMMDD')
  4  ORDER BY name;

NAME
----------------------------------------------------------------------
J

1 row selected.

SQL>
SQL>
SQL> drop table employee;

Table dropped.

SQL>








13.21.TO_DATE
13.21.1.Specifying a Datetime Format for TO_DATE() function
13.21.2.Using the YY Format
13.21.3.Using the RR Format
13.21.4.TO_CHAR(TO_DATE('04-JUL-15', 'DD-MON-RR'), 'DD-MON-YYYY')
13.21.5.TO_DATE function to convert from characters to dates explicitly
13.21.6.TO_DATE(x[, format]) converts the x string to a datetime
13.21.7.TO_DATE() converts the strings 04-JUL-2006 to the date July 4, 2006
13.21.8.Specifying Times
13.21.9.TO_DATE() with INSERT statement
13.21.10.DBMS_OUTPUT.PUT_LINE(TO_DATE ('1/1'));
13.21.11.DBMS_OUTPUT.PUT_LINE(TO_DATE ('6/1996'));
13.21.12.DBMS_OUTPUT.PUT_LINE(TO_DATE ('12-APR-09'));
13.21.13.DBMS_OUTPUT.PUT_LINE(TO_DATE ('19991205'));
13.21.14.DBMS_OUTPUT.PUT_LINE(TO_DATE ('1/1/1'))
13.21.15.Birthday before 1940
13.21.16.Catch exception from to_date function