DATES

From rbachwiki
Revision as of 18:59, 19 November 2017 by Bacchas (talk | contribs)
(diff) ← Older revision | Latest revision (diff) | Newer revision → (diff)
Jump to navigation Jump to search

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'
SELECT order#, orderdate
FROM orders
WHERE orderdate < '01-APR-09'
TO_DATE('November 3, 2001', 'Month dd yyyy') - > 03-Nov-2001


Back To Top- Home - Category