Re: help needed on datetime functions
On Wednesday 05 December 2001 16:40, you wrote:
> hi everybody
> i want to take diff of datetime format columns.
> Is it possible using direct '-' arithmatic..
> It gives result as:
>
> 2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126
> 2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350
>
> First row is clear but i'm not getting second row's
> diff.. **((63)50)** how it comes.
>
> Is there any diff way to find diff of datetime
> columns. (any mysql func.)
> OR
> It is not possible by using any standard mysql
> funcions and one has to write his own program to do
> this.
You can use something like this:
SEC_TO_TIME(UNIX_TIMESTAMP("2001-11-03 16:11:50") -
UNIX_TIMESTAMP("2001-11-03 15:48:00"))
which would return
00:23:50
hth
--
Jason Wong -> Gremlins Associates -> www.gremlins.com.hk
/*
Universe, n.:
The problem.
*/
-
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
help needed on datetime functions
hi everybody i want to take diff of datetime format columns. Is it possible using direct '-' arithmatic.. It gives result as: 2001-11-03 15:43:47 - 2001-11-03 15:42:21 = 126 2001-11-03 16:11:50 - 2001-11-03 15:48:00 = 6350 First row is clear but i'm not getting second row's diff.. **((63)50)** how it comes. Is there any diff way to find diff of datetime columns. (any mysql func.) OR It is not possible by using any standard mysql funcions and one has to write his own program to do this. plz reply thanks in advance For Stock Quotes, Finance News, Insurance, Tax Planners, Mutual Funds... Visit http://in.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
