Difference between revisions of "DATE BUILT IN FUNCTIONS"
Jump to navigation
Jump to search
| Line 15: | Line 15: | ||
SELECT TO_CHAR(HIRE_DATE, fmMonth dd, YYYY') output -> June 7 1994 | SELECT TO_CHAR(HIRE_DATE, fmMonth dd, YYYY') output -> June 7 1994 | ||
SELECT TO_CHAR(HIRE_DATE, 'fmMonth ddth, YYYY') output -> June 7th, 1994 | SELECT TO_CHAR(HIRE_DATE, 'fmMonth ddth, YYYY') output -> June 7th, 1994 | ||
SELECT TO_CHAR(SYSDATE, 'hh:mm')output-> 02:07 | |||
SELECT TO_CHAR(SYSDATE, 'hh:mm pm') output -> 02:07 am | |||
SELECT TO_CHAR(SYSDATE, 'hh:mm:ss pm') output-> 02:07:23 am | |||
[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | [[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]] | ||
Latest revision as of 18:45, 19 November 2017
MONTHS_BETWEEN() - RETURNS THE NUMBER OF MONTHS BETWEEN 2 DATES
MONTHS_BETWEEN('01-MAR-15','01-JAN-15')=2
ADD_MONTHS() - ADDS MONTHS TO A DATE
ADD_MONTHS('01-MAR-15',3)='01-JUN-15'
LAST_DAY() - RETURNS THE LAST DAY OF THE MONTH
LAST_DAY('01-MAR-15')='31-MAR-15'
NEXT_DAY() - RETURNS THE NEXT DAY MENTIONED IN THE ARGUMENT
NEXT_DAY('01-MAR-15','WEDNESDAY')='04-MAR-15'
DATE CONVERSION TO CHARACTER DATA
SELECT TO_CHAR(HIRE_DATE, 'Month dd, YYYY') output -> June 07, 1994 SELECT TO_CHAR(HIRE_DATE, fmMonth dd, YYYY') output -> June 7 1994 SELECT TO_CHAR(HIRE_DATE, 'fmMonth ddth, YYYY') output -> June 7th, 1994
SELECT TO_CHAR(SYSDATE, 'hh:mm')output-> 02:07 SELECT TO_CHAR(SYSDATE, 'hh:mm pm') output -> 02:07 am SELECT TO_CHAR(SYSDATE, 'hh:mm:ss pm') output-> 02:07:23 am