/*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;
A voting comment increases the vote count for the chosen answer by one.
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one.
So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
SantiBZ_07032022_1744
Highly Voted 1 year, 11 months agosalander71
Most Recent 3 months, 1 week agolucemqy
1 year, 2 months agodilshod
1 year, 6 months agoDarnun
1 year, 9 months agojfc1
1 year, 10 months ago