Adding hours to NOW() function

alsaffar

Hi there,

I have a problem of NOW() function that I'm using when I want to insert the DATETIME in my table.

The problem is the time that will be inserted in the DB is the server time which is in my case is GMT time. what should I do incase I want to add 3 hours on that day before I insert it in the DB. How I can reach my target?

hand

SELECT DATE_ADD(now(), INTERVAL 3 HOUR);
http://www.mysql.com/doc/en/Date_and_time_functions.html

alsaffar

This is cool for the NOW() function in SQL.

But how can I add 3 hours in UNIX to (lets say):

$CurrentTime = date ("l dS of F Y h:i:s A");

NiXXeD

Well, I thought the date function had 2 parameters, the format string, and the number of seconds (unix timestamp). If you wanted to add 1 second to "now" you'd just use time()+1. If you want to add 1 minute, time()+60. An hour, time()+3600. 3 hours, time()+10800. Hope that helps.

alsaffar

But how I can add n hours to the following formula:

$CurrentTime = date ("l dS of F Y h:i:s A");