mastreo Posted February 12, 2008 Share Posted February 12, 2008 is there any way to change the week start day from sunday to saturday using mysql query....normally week starts from sunday, but i need week starts from saturday and ends on friday? can anyone help on this? Quote Link to comment https://forums.phpfreaks.com/topic/90649-i-need-to-change-the-mysql-week-start-date-and-end-date/ Share on other sites More sharing options...
redbullmarky Posted February 12, 2008 Share Posted February 12, 2008 Hi and welcome to the forums Please note that where you posted this topic initially (Competitions) is for just that - competitions. Please get yourself acquainted with the different boards here and read the descriptions before posting. Cheers Quote Link to comment https://forums.phpfreaks.com/topic/90649-i-need-to-change-the-mysql-week-start-date-and-end-date/#findComment-464820 Share on other sites More sharing options...
beebum Posted February 12, 2008 Share Posted February 12, 2008 As far as I can tell, you can only use Sunday or Monday. http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html Quote Link to comment https://forums.phpfreaks.com/topic/90649-i-need-to-change-the-mysql-week-start-date-and-end-date/#findComment-464837 Share on other sites More sharing options...
Recommended Posts
Join the conversation
You can post now and register later. If you have an account, sign in now to post with your account.