DATES - Revision history

Bacchas at 18:59, 19 November 2017

2017-11-19T18:59:00Z

← Older revision		Revision as of 18:59, 19 November 2017
Line 13:		Line 13:
	FROM orders		FROM orders
	WHERE orderdate < '01-APR-09'		WHERE orderdate < '01-APR-09'

			TO_DATE('November 3, 2001', 'Month dd yyyy') - > 03-Nov-2001


	[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas at 17:57, 24 October 2017

2017-10-24T17:57:40Z

← Older revision		Revision as of 17:57, 24 October 2017
Line 9:		Line 9:
	FROM books		FROM books
	WHERE pubdate = '21-JAN-05'		WHERE pubdate = '21-JAN-05'

			SELECT order#, orderdate
			FROM orders
			WHERE orderdate < '01-APR-09'


	[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]		[[#Rules for Dates\|Back To Top]]-[[Main_Page\| Home]] - [[Oracle_SQL\|Category]]

Bacchas: Created page with "==Rules for Dates== Sometimes you need to use a date as a search condition. Oracle 11g displays dates in the default format DD-MON-YY, with MON being the standard three-letter..."

2017-10-24T16:45:27Z

Created page with "==Rules for Dates== Sometimes you need to use a date as a search condition. Oracle 11g displays dates in the default format DD-MON-YY, with MON being the standard three-letter..."

New page

==Rules for Dates==
Sometimes you need to use a date as a search condition. Oracle 11g displays dates in the
default format DD-MON-YY, with MON being the standard three-letter abbreviation for the
month. Because the Pubdate field contains letters and hyphens, it’s not considered a
numeric value when Oracle 11g performs searches. Therefore, a date value must be
enclosed in single quotation marks

SELECT *
FROM books
WHERE pubdate = '21-JAN-05'

[[#Rules for Dates|Back To Top]]-[[Main_Page| Home]] - [[Oracle_SQL|Category]]