Re: "What date/time was it 7 hours ago"?

You could convert it to a timestamp using strtotime(), subtract 7*60*60, then convert it back to a string with strftime(). -Steve On Monday, April 15, 2002, at 09:50 AM, Torkil Johnsen wrote:

"What date/time was it 7 hours ago"? I'm just trying to make a log using mysql/php This log is kinda supposed to show the time, local to the user. So I store datetime on the format YYYY-MM-DD HH:MM:SS in a datetime field. Using the php date function to get the date. This will store the time that right then ON THE SERVER. Now, when fetching data from the mysql table, I want to display what the time WAS, LOCALLY (where I'm at, not the server) when the log entry was made. So. How do I make a function that takes in YYYY-MM-DD HH:MM:SS and spits out the YYYY-MM-DD HH:MM:SS minus... for instance, 7 hours? "What date/time was it 7 hours ago"? -- PHP General Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php