DATE BUILT IN FUNCTIONS - Revision history

Bacchas at 18:45, 19 November 2017

2017-11-19T18:45:54Z

← Older revision		Revision as of 18:45, 19 November 2017
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]]

Bacchas at 18:42, 19 November 2017

2017-11-19T18:42:33Z

← Older revision		Revision as of 18:42, 19 November 2017
Line 10:		Line 10:
	==NEXT_DAY() - RETURNS THE NEXT DAY MENTIONED IN THE ARGUMENT ==		==NEXT_DAY() - RETURNS THE NEXT DAY MENTIONED IN THE ARGUMENT ==
	NEXT_DAY('01-MAR-15','WEDNESDAY')='04-MAR-15'		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 Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Select Command\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas: /* ADD_MONTHS() - ADDS MONTHS TO A DATE */

2017-11-05T19:34:44Z

ADD_MONTHS() - ADDS MONTHS TO A DATE

← Older revision		Revision as of 19:34, 5 November 2017
Line 3:		Line 3:

	==ADD_MONTHS() - ADDS MONTHS TO A DATE ==		==ADD_MONTHS() - ADDS MONTHS TO A DATE ==
	ADD_MONTHS('01-MAR-15',3)='31-~~MAR~~-15'		ADD_MONTHS('01-MAR-15',3)='01-JUN-15'

	==LAST_DAY() - RETURNS THE LAST DAY OF THE MONTH==		==LAST_DAY() - RETURNS THE LAST DAY OF THE MONTH==

Bacchas: Created page with "==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-1..."

2017-11-05T19:33:23Z

Created page with "==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-1..."

New page

==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)='31-MAR-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'

[[#Select Command|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]