May 22, 2014 at 10:49 pm
Hi All,
I'm just a little confused, when running the query
SELECT WEEKDAY(CURDATE( )) FROM dual
the current date being Friday, 23 May 2014, the weekday number returned is 4. Correct me if I am wrong, but should this not be returning 6?
May 22, 2014 at 11:08 pm
is that are SQL functions?
_______________________________________________________________
To get quick answer follow this link:
http://www.sqlservercentral.com/articles/Best+Practices/61537/
May 22, 2014 at 11:09 pm
It's MySQL
May 22, 2014 at 11:57 pm
lclaassen (5/22/2014)
Hi All,I'm just a little confused, when running the query
SELECT WEEKDAY(CURDATE( )) FROM dual
the current date being Friday, 23 May 2014, the weekday number returned is 4. Correct me if I am wrong, but should this not be returning 6?
it depends what local settings you have configured on your system, if you week 1st date is sunday then it will be 6, as per the provided information your 1st day is currently set to Tuesday.
May 23, 2014 at 12:08 am
I guess you have posted it on wrong forum.
--rhythmk
------------------------------------------------------------------
To post your question use below link
https://www.sqlservercentral.com/articles/forum-etiquette-how-to-post-datacode-on-a-forum-to-get-the-best-help
🙂
May 23, 2014 at 12:15 am
How can I change my 1st weekday?
May 23, 2014 at 12:28 am
Hmmmm you can set in sql server, but in mysql u cannot.
this might help you.
http://stackoverflow.com/questions/1202919/mysql-dayofweek-my-week-begins-with-monday
Viewing 7 posts - 1 through 6 (of 6 total)
You must be logged in to reply to this topic. Login to reply