4.3.2.8. Temporal functions
The following functions support general temporal operations.
- day of year( date )
Returns the Gregorian number of the day of the year.
Expand 表4.61 Parameters Parameter Type datedateordate and timeExample
day of year( date(2019, 9, 17) ) = 260- day of week( date )
Returns the Gregorian day of the week:
"Monday","Tuesday","Wednesday","Thursday","Friday","Saturday", or"Sunday".Expand 表4.62 Parameters Parameter Type datedateordate and timeExample
day of week( date(2019, 9, 17) ) = "Tuesday"- month of year( date )
Returns the Gregorian month of the year:
"January","February","March","April","May","June","July","August","September","October","November", or"December".Expand 表4.63 Parameters Parameter Type datedateordate and timeExample
month of year( date(2019, 9, 17) ) = "September"- month of year( date )
Returns the Gregorian week of the year as defined by ISO 8601.
Expand 表4.64 Parameters Parameter Type datedateordate and timeExamples
week of year( date(2019, 9, 17) ) = 38 week of year( date(2003, 12, 29) ) = 1 week of year( date(2004, 1, 4) ) = 1 week of year( date(2005, 1, 1) ) = 53 week of year( date(2005, 1, 3) ) = 1 week of year( date(2005, 1, 9) ) = 1