Showing posts with label mysql dayofweek function. Show all posts
Showing posts with label mysql dayofweek function. Show all posts

Monday, 16 July 2012

MYSQL DAYOFWEEK function

MYSQL DAYOFWEEK(date) function
Returns the weekday index for date (1 = Sun, 2 = Mon,3=Tue,4= Wed, 5=Thu, 6= Fri, 7 = Saturday). index values are ODBC standard.
SELECT DAYOFWEEK('2007-02-03');
o/p: 7