Examine this incomplete query:
SELECT DATE '2019-01-01' +
FROM DUAL;
Which three clauses can replace
Examine this incomplete query:
SELECT DATE '2019-01-01' +
FROM DUAL;
Which three clauses can replace
To add 12 hours to the given date, the correct interval clauses are: INTERVAL '720' MINUTE, INTERVAL '0 12' DAY TO HOUR, and INTERVAL '12' HOUR. These options correctly represent an interval of 12 hours. INTERVAL '720' MINUTE directly converts 12 hours into minutes. INTERVAL '0 12' DAY TO HOUR specifies 0 days and 12 hours. INTERVAL '12' HOUR straightforwardly represents 12 hours.
/*A NOOK*/ select date'2019-01-01' + interval '0.5' day from dual; /*01867. 00000 - "the interval is invalid" *Cause: The character string you specified is not a valid interval. *Action: Please specify a valid interval.*/ /*B OK*/ select date'2019-01-01' + interval '720' MINUTE from dual; /*C NOOK*/ select date'2019-01-01' + interval '11:60' HOUR TO MINUTE from dual; /*ORA-01851: los minutos deben estar comprendidos entre 0 y 59 01851. 00000 - "minutes must be between 0 and 59"*/ /*D NOOK*/ select date'2019-01-01' + interval '12:00' HOUR TO SECOND from dual; /*ORA-01867: el intervalo no es válido 01867. 00000 - "the interval is invalid" *Cause: The character string you specified is not a valid interval.*/ /*E OK*/ select date'2019-01-01' + interval '0 12' DAY TO HOUR from dual; /*F OK*/ select date'2019-01-01' + interval '12' HOUR from dual;
BEF is true
b e f are true
BEF are correct ones
BEF are correct