Write a Oracle SQL statement to get the last date of the current month

hamza

Save to bookmark

2022-05-18

179

Write a Oracle SQL statement to get the last date of the current month.

Oracle,

hamza

2022-05-18

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

SELECT TRUNC (LAST_DAY (SYSDATE)) "Last day of current month" FROM DUAL;

Output:

  	Last day of current month
1	2/28/2021 12:00:00 AM

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

total answers (1)