Peter,
I would do something like this:
(UNIX_TIMESTAMP(Column Two) - UNIX_TIMESTAMP(Column One))/3600
to give you the hours....not sure about the minutes, but this should get
you going!
HTH,
Cory
'$valid_user' ";
On Tue, 2002-12-03 at 10:45, Peter Abilla wrote:
> Suppose I have a datetime in the following format:
>
> Column One Column Two
> 1999-09-17 16:30:18 1999-09-18 13:30:18
>
> I want to calculate the minutes like
>
> (Column Two - Column One) = Total Minutes
>
> I've scoured the mysql site and haven't found something that addresses this.
> Any ideas?
>
> Keyword: sql, query
>
>
>
> ---------------------------------------------------------------------
> 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
--
Cory Hicks <[EMAIL PROTECTED]>
TRI-International
---------------------------------------------------------------------
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
