On Saturday, 2. March 2002 08:11, Hoo Kok Mun wrote: > Hi, > > I have look thru the website on date and time functions but nothing that I > can use. > http://www.mysql.com/doc/D/a/Date_and_time_functions.html > > How do I dynamically calculate how many working hours in a particular > month? Has anyone do it before?
Thats really not the way to calculate the working hours in mysql. You can do it in PHP, or if you really need it within a query, write an UDF/NF for. Regards Georg --------------------------------------------------------------------- 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
