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
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
No comments:
Post a Comment