Date Functions: Last_Day

Description: Returns the last date (not day) of a given month.

LAST_DAY(<date>)
 
SELECT * FROM t;
 
SELECT LAST_DAY(datecol1) FROM t;

Enjoyed this post? Share it!

 

Leave a comment

Your email address will not be published.