It is a known fact thatĀ NLS_FORMAT_DATE default format is DD-MON-RR, but the date literal can be used in multiple forms and still be fit the format. I’ve found the following question a bit tricky because the right answers are A and C. See below for more. All these DATEĀ literals are […]
tutorialspoint.com
2 posts
I’ve found this example very interesting and making you understand DATE data type better. SYSDATE function returns the current system date and time on your local database. But, if your NLS_DATE_FORMAT setting was set to DD-MON-RR, then it will return accordingly per specified format. Same is true about DATE data […]