Write a Oracle SQL statement to get number of days between two given dates

hamza

Save to bookmark

2022-05-18

122

Write a Oracle SQL statement to get number of days between two given dates.

Oracle,

hamza

2022-05-18

need an explanation for this answer? contact us directly to get an explanation for this answer

Oracle Code:

SELECT ROUND ((MONTHS_BETWEEN ('01-May-2024', '01-Dec-2023') * 30), 0) num_of_days FROM DUAL;

Output:

  	NUM_OF_DAYS
1	150

need an explanation for this answer? contact us directly to get an explanation for this answer

total answers (1)