Date Functions : Introduction « Date Timestamp Functions « Oracle PL/SQL Tutorial

1. Oracle PL/SQL Tutorial
2. Date Timestamp Functions
3. Introduction

We must format dates to see all of the information contained in a date column.

We use the TO_CHAR function to do the converting.

SQL> SELECT SYSDATE FROM dual;

SYSDATE
---------
29-MAY-07

SQL>

SQL> SELECT TO_CHAR(SYSDATE, 'ddMONyyyy') Today
  2  FROM dual;

TODAY
---------
29MAY2007

SQL>