RE: How can I get the first and the last day of month

[snip] How can I get the first and the last day of the month? [/snip] http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html last_day() for last day of the month. The first day is always the first. -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsub

How can I get the first and the last day of month

I get the current date with SELECT CURDATE() How can I get the first and the last day of the month?