16 . Il linguaggio SQL Vers . 9.3 – Marzo 2024
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 . 82