LAST_DAY, TO_CHAR, TO_DATE : Introduction « Date Timestamp Functions « Oracle PL/SQL Tutorial






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

SQL> SELECT TO_CHAR(LAST_DAY(TO_DATE('23SEP2006','ddMONyyyy')), 'Month dd, yyyy') FROM dual;

TO_CHAR(LAST_DAY(T
------------------
September 30, 2006

SQL>
SQL>








13.1.Introduction
13.1.1.Using Datetime Functions
13.1.2.Timestamp-Related Functions
13.1.3.Time Interval Related Functions
13.1.4.Date Functions
13.1.5.LAST_DAY, TO_CHAR, TO_DATE
13.1.6.select date '1954-08-11' + 10000 as 10,000 days
13.1.7.Differences Between Dates