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 […]

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 […]