Combine to_char, add_months and to_date function : TO_DATE « Date Timezone « Oracle PL / SQL






  1. Oracle PL / SQL
  2. Date Timezone
  3. TO_DATE

Combine to_char, add_months and to_date function

   

SQL>
SQL> SELECT TO_CHAR(ADD_MONTHS(TO_DATE('01-JAN-2005 19:15:26','DD-MON-YYYY HH24:
MI:SS'), 2), 'DD-MON-YYYY HH24:MI:SS') FROM dual;

TO_CHAR(ADD_MONTHS(T
--------------------
01-MAR-2005 19:15:26

SQL>








Related examples in the same category

1.TO_CHAR(ADD_MON(TO_DATE('29-FEB-2000','DD-MON-YYYY'),1),'DD-MON-YYYY')
2.Use to_date in insert statement
3.Using TO_DATE Within PL/SQL
4.to_date() and insert statement