Bug #14883 Wanted "mode" parameter for functions dayofweek(), weekday()

• Submitted: 11 Nov 2005 19:30
• Modified: 15 Dec 2010 11:39
• Reporter: Gisbert Selke (Basic Quality Contributor)
• Status: Verified
• Category: MySQL Server: General
• Severity: S4 (Feature request)
• Version: 5.0.15
• OS: Windows (Win XP)
• CPU Architecture: Any
• Tags: qc

[11 Nov 2005 19:30] Gisbert Selke

Description:
It would be nice if functions dayofweek() and weekday() accepted an optional mode
parameter similar to the one used in week() (i.e., Monday vs. Sunday as
first day of week; first day = 1 or = 0).
Apparently, there are a number of conventions about this, and it would be nice to be able to cater for them, just like in the week() case.

How to repeat:
n/a

[15 Dec 2010 11:39] Valeriy Kravchuk

Thank you for the feature request.