From: "Joel" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Thursday, August 09, 2001 3:01 AM
Subject: Date calculations with php and mysql
> How do I find the elapsed time on a timestamp field?
SELECT NOW() - field AS elapsed FROM table?
Alex
--
Alex Page, I
At 9:01 PM -0500 8/8/01, Joel wrote:
>How do I find the elapsed time on a timestamp field?
A timestamp is a single value. You can't find elapsed time without
a point of reference to measure it against (two values). What's
your point of reference?
If you have two timestamps, convert each of the
How do I find the elapsed time on a timestamp field?
I know there must be a way but I can't find it in the Mysql Docs.
I am using php 4 and the latest mysql i386 binary.
Thank you very much
Joel