16. Il linguaggio SQL Vers. 11.2 – Febbraio 2026
SELECT DATE( NOW()); N. B.( equivale a SELECT CURRENT _ DATE())
Risultato:
+-------------- + | DATE( NOW()) | +-------------- + | 2015-03-26 | +-------------- +
SELECT TIME( NOW()); N. B.( equivale a SELECT CURRENT _ TIME())
Risultato:
+-------------- + | TIME( NOW()) | +-------------- + | 15:30:19 | +-------------- +
SELECT DAY( NOW());
Risultato:
+------------ + | DAY( NOW()) | +------------ +
| 26 | +------------ +
SELECT DAYOFWEEK( NOW()); // dom = 0, lun = 1, mar = 2, merc = 3, etc, etc
Risultato:
+------------------ + | DAYOFWEEK( NOW()) | +------------------ + | 5 | +------------------ +
SELECT DAYOFYEAR( NOW()); // 1 gennaio = giorno 1, etc. etc.
Risultato:
+------------------ + | DAYOFYEAR( NOW()) | +------------------ + | 85 | +------------------ +
SELECT MONTH( NOW()); // genn = 1, febb = 2, mar = 3, etc. etc.
Risultato:
+-------------- +
| MONTH( NOW()) | +-------------- + | 3 | +-------------- +
SELECT YEAR( NOW());
Risultato:
+------------- + | YEAR( NOW()) | +------------- + | 2015 | +------------- +
Autore: Rio Chierego( email: riochierego @ libero. it- sito web: www. riochierego. it) Pag. 83