tags:

views:

36

answers:

1
Q: 

MySQL / PHP - Time Question

In my DB I stored the time of the last page refresh in a TIME column. I want to compare the last page refresh to the current time now and find out how many 5 minuet periods have passed?

I was thinking take the last page refresh and subtract it from the current time then divide by 5. But I don't know about how things are formatted.

Help me please!

+1  A:  
SELECT *, FLOOR(((UNIX_TIMESTAMP()-time_field)/300)) AS periods FROM table

Im not sure for if UNIX_TIMESTAMP() returns correct timestamp, you will have to check it ;)
EDIT: checked it myself and its working great ;)

cichy  2010-09-06 22:00:46
im assuming unix_timestamp is the current time and time field is the last page refresh? sorry kinda new to php >.<
 2010-09-06 22:14:46
Yes, in this query you should only change name of the table, and "time_field" to name of the column you have your last refresh, and it should work right away.
cichy  2010-09-06 22:23:06
ok ill try it! thanks. but where does it tell me how many 5 min periods have passed?
 2010-09-06 22:24:29
I added name of the field where you will have 5 min periods counted, if you want to change it to 10 min etc, just change 300 to (60 * x) where x is minutes.
cichy  2010-09-06 22:26:40
thank you i will try it.
 2010-09-06 22:27:57

related questions

Unix gettimeofday() - compatible algorithm for determining week within month?
How do I convert a date/time to epoch time (aka unix time -- seconds since 1970) in Perl?
calculate elapsed time in flash
time.sleep -- sleeps thread or process?
Elapsed time without considering weekends and bank holidays in Java
What languages do date, time, and calendar operations really well?
Measure Total Network Transfer Time from Servlets
Time Parsing in Flex
How can I calculate time schedules (for free)?
What is your choice for a Time Managment Solution?
How can you insure your code runs with no variability in execution time due to cache?
How do you measure the time a function takes to execute?
Resetting detection of source file changes
How to parse relative time?
What is the simplest way to find the difference between 2 times in python?
Datetime arithmetic with a string in Ruby
What should we do to prepare for 2038?
What is the most efficient way to populate a time (or time range)?
“rusage” statistics
If I have a PHP string in the format YYYY-DD-MM and a timestamp in MySQL, is there a good way to convert between them?
How to display "12 minutes ago" etc in a PHP webpage?
Dealing with PHP server and MySQL server in different time zones
Design debate: what are good ways to store and manipulate versioned objects?
Help with CRON jobs?
How can I determine a web user's time zone?