Bug #28389 | Nr of workdays calculation like excel | ||
---|---|---|---|
Submitted: | 12 May 2007 16:45 | Modified: | 3 Oct 2009 18:53 |
Reporter: | Ivo van Kamp | Email Updates: | |
Status: | No Feedback | Impact on me: | |
Category: | MySQL Server: User-defined functions ( UDF ) | Severity: | S4 (Feature request) |
Version: | 5.1 | OS: | Linux (Xubuntu 7.04) |
Assigned to: | CPU Architecture: | Any | |
Tags: | business days, Contribution, DATEDIFF, networkdays, workdays |
[12 May 2007 16:45]
Ivo van Kamp
[12 May 2007 17:29]
MySQL Verification Team
Thank you for the bug report feature request.
[12 May 2007 22:10]
Ivo van Kamp
Bugfix. Misinterpreted day of week..
Attachment: workdays.c (application/octet-stream, text), 4.81 KiB.
[12 May 2007 22:27]
Ivo van Kamp
Thank you for having me. If you like I can try to write a patch to create a workdays function.
[19 May 2007 6:38]
Ivo van Kamp
Patch file against 5.0.21 to add a workdays function. Apply with patch -Np0 -i [patchfile] in the root dir of the source tree.
Attachment: mysql-5.0.21.workdays.patch (text/x-diff), 3.68 KiB.
[19 May 2007 6:55]
Ivo van Kamp
Patch tested on MySQL 5.0.21, Linux Xubuntu 7.04.
[19 May 2007 7:01]
Ivo van Kamp
mysql> select workdays('2007-05-13','2007-05-19'); +-------------------------------------+ | workdays('2007-05-13','2007-05-19') | +-------------------------------------+ | 5 | +-------------------------------------+ 1 row in set (0.00 sec) mysql> select workdays('2007-05-19','2007-05-13'); +-------------------------------------+ | workdays('2007-05-19','2007-05-13') | +-------------------------------------+ | -5 | +-------------------------------------+ 1 row in set (0.00 sec)
[19 May 2007 17:43]
Ivo van Kamp
Added tag "Contribution"
[3 Sep 2009 18:53]
Liz Drachnik
Hello Ivo In order for us to continue the process of reviewing your contribution to MySQL - We need you to review and sign the Sun|MySQL contributor agreement (the "SCA") The process is explained here: http://forge.mysql.com/wiki/Sun_Contributor_Agreement Getting a signed/approved SCA on file will help us facilitate your contribution-- this one, and others in the future. Thank you !
[3 Oct 2009 23:00]
Bugs System
No feedback was provided for this bug for over a month, so it is being suspended automatically. If you are able to provide the information that was originally requested, please do so and change the status of the bug back to "Open".