Re: [PHP] determining time difference between two timestamp fields.
On 25 May 2010 15:55, Bruce Gilbert webgu...@gmail.com wrote:
Here is the situation. I have a form which sets a timestamp when a
user logs in using UPDATE in SQL. The field is called
'login_timestamp' and is in a table called 'Candidates'. I have
another timestamp which is set when a user submits the form data into
the DB and it is called 'submit_timestamp' . What I want to do is
determine the amount of time the user takes to complete the form by
subtracting the 'login_timestamp' time form the 'submit_timestamp'
time. I am using SQL to extract the data here.
$sql = SELECT Responses.name,Answers,submit_timestamp,login_timestamp
FROM Responses LEFT JOIN Candidates USING (user_id);
and then to display the timestamp in readable form.
echo trthCompletion Time:/th/trtrtd . date('F j, Y
g:i:sa', strtotime($row[login_timestamp])) . /td/tr;
so I need to know how to subtract from two timestamp fields, two
different tables and come up with the difference in minutes.
In case you're using MySQL, timediff can do the job:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff
Otherwise, just do strtotime(endtime) - strtotime(starttime) / 60.
That's the difference in minutes.
Regards
Peter
--
hype
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
BeWelcome/Couchsurfing: Fake51
Twitter: http://twitter.com/kafe15
/hype
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] determining time difference between two timestamp fields.
Thanks. I know my syntax isn't quite right, but is this close to what
I need to do?
echo trthCompletion Time:/th/trtrtd . date('F j, Y
g:i:sa', strtotime($row[login_timestamp] - [submit_timestamp])/60)
. /td/tr;
On Tue, May 25, 2010 at 10:01 AM, Peter Lind peter.e.l...@gmail.com wrote:
On 25 May 2010 15:55, Bruce Gilbert webgu...@gmail.com wrote:
Here is the situation. I have a form which sets a timestamp when a
user logs in using UPDATE in SQL. The field is called
'login_timestamp' and is in a table called 'Candidates'. I have
another timestamp which is set when a user submits the form data into
the DB and it is called 'submit_timestamp' . What I want to do is
determine the amount of time the user takes to complete the form by
subtracting the 'login_timestamp' time form the 'submit_timestamp'
time. I am using SQL to extract the data here.
$sql = SELECT Responses.name,Answers,submit_timestamp,login_timestamp
FROM Responses LEFT JOIN Candidates USING (user_id);
and then to display the timestamp in readable form.
echo trthCompletion Time:/th/trtrtd . date('F j, Y
g:i:sa', strtotime($row[login_timestamp])) . /td/tr;
so I need to know how to subtract from two timestamp fields, two
different tables and come up with the difference in minutes.
In case you're using MySQL, timediff can do the job:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff
Otherwise, just do strtotime(endtime) - strtotime(starttime) / 60.
That's the difference in minutes.
Regards
Peter
--
hype
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
BeWelcome/Couchsurfing: Fake51
Twitter: http://twitter.com/kafe15
/hype
--
::Bruce::
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] determining time difference between two timestamp fields.
On 25 May 2010 16:14, Bruce Gilbert webgu...@gmail.com wrote:
Thanks. I know my syntax isn't quite right, but is this close to what
I need to do?
echo trthCompletion Time:/th/trtrtd . date('F j, Y
g:i:sa', strtotime($row[login_timestamp] - [submit_timestamp])/60)
. /td/tr;
No. Assuming that your timestamp is of the -mm-dd HH:ii:ss form,
you need to do (strtotime([submit_timestamp]) -
strtotime($row[login_timestamp]))/60.
Regards
Peter
On Tue, May 25, 2010 at 10:01 AM, Peter Lind peter.e.l...@gmail.com wrote:
On 25 May 2010 15:55, Bruce Gilbert webgu...@gmail.com wrote:
Here is the situation. I have a form which sets a timestamp when a
user logs in using UPDATE in SQL. The field is called
'login_timestamp' and is in a table called 'Candidates'. I have
another timestamp which is set when a user submits the form data into
the DB and it is called 'submit_timestamp' . What I want to do is
determine the amount of time the user takes to complete the form by
subtracting the 'login_timestamp' time form the 'submit_timestamp'
time. I am using SQL to extract the data here.
$sql = SELECT Responses.name,Answers,submit_timestamp,login_timestamp
FROM Responses LEFT JOIN Candidates USING (user_id);
and then to display the timestamp in readable form.
echo trthCompletion Time:/th/trtrtd . date('F j, Y
g:i:sa', strtotime($row[login_timestamp])) . /td/tr;
so I need to know how to subtract from two timestamp fields, two
different tables and come up with the difference in minutes.
In case you're using MySQL, timediff can do the job:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff
Otherwise, just do strtotime(endtime) - strtotime(starttime) / 60.
That's the difference in minutes.
Regards
Peter
--
hype
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
BeWelcome/Couchsurfing: Fake51
Twitter: http://twitter.com/kafe15
/hype
--
::Bruce::
--
hype
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
BeWelcome/Couchsurfing: Fake51
Twitter: http://twitter.com/kafe15
/hype
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] determining time difference between two timestamp fields.
Here is what I currently have.
echo trthCompletion Time:/th/trtrtd .
(strtotime($row['submit_timestamp']) -
strtotime($row['login_timestamp']))/60 , /td/tr;
this gives me an output of 21235172.75
not sure what format that is in? I was hoping for something like 60
minutes, 30 minutes etc. Don't need the days or seconds. The MySQL
timestamp is in this format.
2010-05-17 11:32:45 - 2010-05-17 12:26:13
On Tue, May 25, 2010 at 11:11 AM, Peter Lind peter.e.l...@gmail.com wrote:
On 25 May 2010 16:14, Bruce Gilbert webgu...@gmail.com wrote:
Thanks. I know my syntax isn't quite right, but is this close to what
I need to do?
echo trthCompletion Time:/th/trtrtd . date('F j, Y
g:i:sa', strtotime($row[login_timestamp] - [submit_timestamp])/60)
. /td/tr;
No. Assuming that your timestamp is of the -mm-dd HH:ii:ss form,
you need to do (strtotime([submit_timestamp]) -
strtotime($row[login_timestamp]))/60.
Regards
Peter
On Tue, May 25, 2010 at 10:01 AM, Peter Lind peter.e.l...@gmail.com wrote:
On 25 May 2010 15:55, Bruce Gilbert webgu...@gmail.com wrote:
Here is the situation. I have a form which sets a timestamp when a
user logs in using UPDATE in SQL. The field is called
'login_timestamp' and is in a table called 'Candidates'. I have
another timestamp which is set when a user submits the form data into
the DB and it is called 'submit_timestamp' . What I want to do is
determine the amount of time the user takes to complete the form by
subtracting the 'login_timestamp' time form the 'submit_timestamp'
time. I am using SQL to extract the data here.
$sql = SELECT Responses.name,Answers,submit_timestamp,login_timestamp
FROM Responses LEFT JOIN Candidates USING (user_id);
and then to display the timestamp in readable form.
echo trthCompletion Time:/th/trtrtd . date('F j, Y
g:i:sa', strtotime($row[login_timestamp])) . /td/tr;
so I need to know how to subtract from two timestamp fields, two
different tables and come up with the difference in minutes.
In case you're using MySQL, timediff can do the job:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff
Otherwise, just do strtotime(endtime) - strtotime(starttime) / 60.
That's the difference in minutes.
Regards
Peter
--
hype
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
BeWelcome/Couchsurfing: Fake51
Twitter: http://twitter.com/kafe15
/hype
--
::Bruce::
--
hype
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
BeWelcome/Couchsurfing: Fake51
Twitter: http://twitter.com/kafe15
/hype
--
::Bruce::
--
PHP General Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
Re: [PHP] determining time difference between two timestamp fields.
On Tue, 2010-05-25 at 12:46 -0400, Bruce Gilbert wrote:
Here is what I currently have.
echo trthCompletion Time:/th/trtrtd .
(strtotime($row['submit_timestamp']) -
strtotime($row['login_timestamp']))/60 , /td/tr;
this gives me an output of 21235172.75
not sure what format that is in? I was hoping for something like 60
minutes, 30 minutes etc. Don't need the days or seconds. The MySQL
timestamp is in this format.
2010-05-17 11:32:45 - 2010-05-17 12:26:13
On Tue, May 25, 2010 at 11:11 AM, Peter Lind peter.e.l...@gmail.com wrote:
On 25 May 2010 16:14, Bruce Gilbert webgu...@gmail.com wrote:
Thanks. I know my syntax isn't quite right, but is this close to what
I need to do?
echo trthCompletion Time:/th/trtrtd . date('F j, Y
g:i:sa', strtotime($row[login_timestamp] - [submit_timestamp])/60)
. /td/tr;
No. Assuming that your timestamp is of the -mm-dd HH:ii:ss form,
you need to do (strtotime([submit_timestamp]) -
strtotime($row[login_timestamp]))/60.
Regards
Peter
On Tue, May 25, 2010 at 10:01 AM, Peter Lind peter.e.l...@gmail.com
wrote:
On 25 May 2010 15:55, Bruce Gilbert webgu...@gmail.com wrote:
Here is the situation. I have a form which sets a timestamp when a
user logs in using UPDATE in SQL. The field is called
'login_timestamp' and is in a table called 'Candidates'. I have
another timestamp which is set when a user submits the form data into
the DB and it is called 'submit_timestamp' . What I want to do is
determine the amount of time the user takes to complete the form by
subtracting the 'login_timestamp' time form the 'submit_timestamp'
time. I am using SQL to extract the data here.
$sql = SELECT Responses.name,Answers,submit_timestamp,login_timestamp
FROM Responses LEFT JOIN Candidates USING (user_id);
and then to display the timestamp in readable form.
echo trthCompletion Time:/th/trtrtd . date('F j, Y
g:i:sa', strtotime($row[login_timestamp])) . /td/tr;
so I need to know how to subtract from two timestamp fields, two
different tables and come up with the difference in minutes.
In case you're using MySQL, timediff can do the job:
http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_timediff
Otherwise, just do strtotime(endtime) - strtotime(starttime) / 60.
That's the difference in minutes.
Regards
Peter
--
hype
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
BeWelcome/Couchsurfing: Fake51
Twitter: http://twitter.com/kafe15
/hype
--
::Bruce::
--
hype
WWW: http://plphp.dk / http://plind.dk
LinkedIn: http://www.linkedin.com/in/plind
BeWelcome/Couchsurfing: Fake51
Twitter: http://twitter.com/kafe15
/hype
--
::Bruce::
The value returned from strtotime() is a timestamp, the value you output
from MySQL isn't a timestamp, it's a string-formatted timestamp. If you
need to format a timestamp use the date() function.
Thanks,
Ash
http://www.ashleysheridan.co.uk
