Last-of-Month

Returns the last day of the month from a date or datetime value.

Syntax

last-of-month (date_exp | datetime_exp)

Example

last-of-month (2007-03-21)

Returns the result: 03/31/2007 00:00