Extraire l'année d'une date:
Le mois:Code:
1
2 SELECT EXTRACT (YEAR from champ_date) FROM table
Le jour:Code:
1
2 SELECT EXTRACT (month from champ_date) FROM table
Le n° de semaineCode:
1
2 SELECT EXTRACT (day from champ_date) FROM table
Code:
1
2 SELECT EXTRACT (week from champ_date) FROM table