A session's NLS_DATE_FORMAT is set to DD Mon YYYY. Which two queries return the value 1 Jan 2019?

The correct answer is B. SELECT DATE `2019-01-01' FROM DUAL; E. SELECT TO_DATE(`2019-01-01', `YYYY-MM-DD') FROM DUAL. select date'2015-01-10' d from dual union SELECT to_date( '01-01-2007' , 'DD-MM-YYYY') Tarih FROM dual; https://livesql.oracle.com/apex/livesql/file/content_BFKOA5UQHDV1MV7HRUDDUEPM4.html

Using Conversion Functions and Conditional Expressions

Question

Options

ASELECT TO_DATE(`2019-01-01') FROM DUAL;
BSELECT DATE `2019-01-01' FROM DUAL;
CSELECT `2019-01-01' FROM DUAL;
DSELECT TO_CHAR(`2019-01-01') FROM DUAL;
ESELECT TO_DATE(2019-01-01', YYYY-MM-DD') FROM DUAL;

How the community answered

(26 responses)

A
4% (1)
B
81% (21)
C
12% (3)
D
4% (1)

Explanation

select date'2015-01-10' d from dual union SELECT to_date( '01-01-2007' , 'DD-MM-YYYY') Tarih FROM dual; https://livesql.oracle.com/apex/livesql/file/content_BFKOA5UQHDV1MV7HRUDDUEPM4.html

Topics

#TO_DATE#DATE literal#NLS_DATE_FORMAT#date display format

Community Discussion

No community discussion yet for this question.

Full 1Z0-071 Practice