LAST_DAY

LAST_DAY function returns the last day of the month in which the input date falls in.

The syntax of this function is: LAST_DAY(datetime-expression).

Example:

The Sysdate in this example is: 10/29/2018 8:24:07 PM

Result: 10/31/2018 8:24:07 PM

Example 2:

The Sysdate in this example is: 10/29/2018 8:24:46 PM

Result: 1/31/2018 8:24:46 PM

Leave a Reply

  • (will not be published)