Before I overcommit myself, I want to find out a few things:
1) How much work does it take to add functions (not procedures)?
2) Is anyone already working on these functions?
3) Is anyone else interested in these functions?
The function I need is a unix-timestamp to human readable formatting
function, preferably one that can create arbitrary formats in non-local
timezones. Say the function accepts one to three arguments, where the
first argument (required) is the timestamp, the second is an optional
strftime-compatible format string (with a reasonable default), and the
third is an optional timezone specifier (defaulting to the local
timezone). I've already got code that will do much of this for US
timezones and GMT, but I've only started looking through what it will take
to add this to MySQL.
Unfortunately, doing this as part of the select statement is the easiest
way to deal with the conversion, as we need the actual timestamp in the
database, and some of the report programs we're evaluating don't do
arbitrary timezones.
The functions I want are SET type support functions, AddToSet, DelFromSet,
and IsInSet, all of which would take two or more arguments, and should be
obvious enough to not need discussion.
My C++ is rusty, as is my yacc, but I'm a decent programmer and don't
think that this is beyond my ability. However, if someone else is doing
this, I'd rather apply myself to other projects.
---------------------------------------------------------------------
Before posting, please check:
http://www.mysql.com/manual.php (the manual)
http://lists.mysql.com/ (the list archive)
To request this thread, e-mail <[EMAIL PROTECTED]>
To unsubscribe, e-mail <[EMAIL PROTECTED]>
Trouble unsubscribing? Try: http://lists.mysql.com/php/unsubscribe.php
