LAST_DAY

Sintassi

LAST_DAY(data)

Descrizione

Accetta un argomento DATE o DATETIME e restituisce il valore corrispondente all'ultimo giorno del mese. Restituisce NULL se l'argomento non è valido.

Esempi

MariaDB [(none)]> SELECT LAST_DAY('2003-02-05');
+------------------------+
| LAST_DAY('2003-02-05') |
+------------------------+
| 2003-02-28             |
+------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SELECT LAST_DAY('2004-02-05');
+------------------------+
| LAST_DAY('2004-02-05') |
+------------------------+
| 2004-02-29             |
+------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SELECT LAST_DAY('2004-01-01 01:01:01');
+---------------------------------+
| LAST_DAY('2004-01-01 01:01:01') |
+---------------------------------+
| 2004-01-31                      |
+---------------------------------+
1 row in set (0.00 sec)

MariaDB [(none)]> SELECT LAST_DAY('2003-03-32');
+------------------------+
| LAST_DAY('2003-03-32') |
+------------------------+
| NULL                   |
+------------------------+
1 row in set, 1 warning (0.00 sec)

Warning (Code 1292): Incorrect datetime value: '2003-03-32'
MariaDB [(none)]>