Roy Lyseng wrote:
Jay Pipes wrote:
Hi all again,
I would like to propose the removal of the WEEK() and WEEKOFYEAR()
functions from Drizzle and the corresponding default_week_format
session variable, sometimes called the "week mode".
Details of these things in MySQL can be found here:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_week
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_weekofyear
http://dev.mysql.com/doc/refman/5.1/en/server-system-variables.html#sysvar_default_week_format
Why am I proposing this? A number of reasons:
1) Simplify the date functions
2) Standardize to format specifiers available in the C std library for
strftime()
3) Removal of custom code that duplicates the strftime() and mktime()
functions in cstdlib (about 1000 lines of code).
IMHO, you should provide something that is more SQL-like than strftime
string codes. The mode variables should go, of course,
Cool. That's the main thing...
> but if these
functions are useful, I think that you should support WEEK(datetime) and
WEEKDAY(datetime).
Yep, nothing against making these functions plugins that return
DATE_FORMAT(datetime, specifier)+0.
I would actually argue that DATE_FORMAT() is the function that is overly
complex...
Agreed.
-jay
_______________________________________________
Mailing list: https://launchpad.net/~drizzle-discuss
Post to : [email protected]
Unsubscribe : https://launchpad.net/~drizzle-discuss
More help : https://help.launchpad.net/ListHelp
