LAST_DAY function returns the last day of the month which the date belongs to. Date is a string in the format ‘yyyy-MM-dd HH:mm:ss’ or ‘yyyy-MM-dd’. The time part of date is ignored.
Syntax: last_day(string date)
Returns 2021-02-28 since it was executed on 6th Feb 2021
Returns the same and the time-part has been ignored.