Difference between revisions of "DATES"
Jump to navigation
Jump to search
(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...") |
(No difference)
|
Revision as of 16:45, 24 October 2017
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'