Re: Date calculations with php and mysql

2001-08-09 Thread Alex Page
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

Re: Date calculations with php and mysql

2001-08-08 Thread Paul DuBois
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

Date calculations with php and mysql

2001-08-08 Thread Joel
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