Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations gkittelson on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Subtract times

Status
Not open for further replies.
buzzt

buzzt

Programmer
Oct 17, 2002
171
CA
I have what I thought would be a very simple question. I want to subtract a time in my database from the current time, and get a difference in minutes. What is the most concise and efficient way to do this?
 
Sort by date Sort by votes
You might fetch the time from the database and convert it to unix epoch time ticks using strototime(). Do the same for the current time.

Subtract the current time from the database time. Divide the remainder by 60.

Want the best answers? Ask the best questions!

TANSTAAFL!!
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

SteveL714
  • Locked
  • Question
mysql_fetch - how to fetch table multiple times
Replies
9
Views
360
ChrisHirst
ChrisHirst
kzn
  • Locked
  • Question
Extract the time from a timestamp 1
Replies
3
Views
100
kzn
kzn
Rohdem
  • Locked
  • Question
PHP session times out very quickly 1
Replies
4
Views
61
Rohdem
Rohdem
NickyJay
  • Locked
  • Question
show record x number of times
Replies
5
Views
80
jpadie
jpadie
Yaik
  • Locked
  • Question
PHP timestamp to/from file
Replies
5
Views
139
vacunita
vacunita

Part and Inventory Search

Sponsor

Back
Top