On 29 Nov 2001, [EMAIL PROTECTED] wrote: > I need to calculate the difference in seconds for two registers type > datetime, My question is if exists some function or trick on mysql for > perform it? I need this for calculate some information about time for > a billing system so I need precision of seconds.
If you are developing on a *nix system and are able to do this at all, I find that the easiest way is to store a unixtime integer and to do the conversion to/from "real" dates in the application. my 2 cents, Sincerely, Jan -- Mr. Jan-Aage Bruvoll IT Project Manager 20 Min Holding, Thurgauerstrasse 40, CH-8050 Zurich Zurich office: +41 1 307 4293, fax: +41 1 307 4281 Office/fax: +44 2072408283 Mobile: +44 7740291600 --------------------------------------------------------------------- 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
