Name that offset

This page shows various time values and conversions to other units. I find this useful when programming in PHP and other languages.

Often, I want to run a SQL query to update a time value in a Drupal db table, and I need to know the delta to add to an existing unix timestamp value to push a value out by 24 hours, 90 days, etc. and would rather not whip out a calculator or do the math on paper...

---

Unit	Seconds	Milliseconds
15 Seconds	15	15000
30 Seconds	30	30000
45 Seconds	45	45000
60 Seconds	60	60000
One Hour	3600	3600000
24 Hours	86400	86400000
7 Days	604800	604800000
One Week	604800	604800000
14 Days	1209600	1209600000
Two Weeks	1209600	1209600000
30 Days	2592000	2592000000
45 Days	3888000	3888000000
60 Days	5184000	5184000000
90 Days	7776000	7776000000
365 Days	31536000	31536000000

Page generated on:
GMT Time: Sun, 07/06/2008 - 7:02am
Unix Time: 1215327765 seconds since January 1 1970 00:00:00 GMT
Local server time: Sat, 07/05/2008 - 11:02pm