Re: DateTime Fields
clarify exactly what you mean. show an example.. you question is confusing. cw --- shahana qureshi [EMAIL PROTECTED] wrote: Please tell me how can I get the date and time values diffently in a single query from 'DateTime' field and the difference of two DateTime fields in HH:MM:SS format. Thanks shahana __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - 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 __ Do you Yahoo!? New DSL Internet Access from SBC Yahoo! http://sbc.yahoo.com - 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
Re: Windows XP Installation Problems
If it installed on Pro at home, it should do the same on another pc running Pro.(in a perfect world maybe) try these troubleshooting steps. FIRST: check you Privileges. Make sure you are authorized to install software on the system. 2ND: instead of double clicking the setup.exe, use XP's add software app, and let XP find the setup.exe and auto install it. 3RD: check the settings, i.e. DMA, Disconnect, etc. of the CD Rom Drive you are using to install the software. Some large apps dont install properly due to the CD Drive's buffer not being large enough to handle a continueous feed of data to the HD. 4TH: copy the complete CD to the HD and install from the hard drive, if necessary. 5TH: Try to install it while in 16-bit mode. (XP option) good luck dude... --- Lukoni, Bryan AG:EX [EMAIL PROTECTED] wrote: I am unable to install either version MySQL 4.03 or the release MySQL 3.23 on a XP professional operating system. No error message is produced, double clicking the setup.exe file only produces a flashing hourglass for a second and then nothing, no error messages. Suggestions anyone. Stange thing, is it installed fine on my home computer which is running XP professional. -=Bryan=- - 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 __ Do You Yahoo!? Yahoo! Finance - Get real-time stock quotes http://finance.yahoo.com - 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
Re: Calculating weeks
I use the Now() function, and I just set my format to ww without parenthesis and it gives me the current week number. --- Georg Richter [EMAIL PROTECTED] wrote: On Monday, 15. July 2002 20:28, Paul W. Reilly wrote: Hello Paul, maybe http://www.mysql.com/doc/D/a/Date_and_time_functions.html could answer your question (Function week() ) Regards Georg Trying to count weeks! I am doing a personal accounting system in php/mysql. I have a report section that groups and calculates expenses into running totals, so that I can see total amount spent in each category. I would like to add a break down to this that will show me the average weekly amount. The calculation is easy enough, but I can not figure out how to get the number of weeks being calculated. Any ideas would be greatly appreciated. Right now I am putting in the number of weeks in manually. - 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 __ Do You Yahoo!? Yahoo! Health - Feel better, live better http://health.yahoo.com - 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