DAYOFWEEK « Date Time « SQL / MySQL






  1. SQL / MySQL
  2. Date Time
  3. DAYOFWEEK
1.Table shows the DAYOFWEEK( ) expressions to use for putting any day of the week first in the sort order
2.Return the day of the week by number: DAYOFWEEK()
3.DAYOFWEEK( ) returns values from 1 to 7, corresponding to Sunday through Saturday.
4.Sorting by Day of Week
5.To produce a day-of-week summary instead, use the DAYOFWEEK( ) function: