[Resolved] Add 9 hours to a timestamp

[Stu]

Hi guys 🙂

I have a database table which includes a timestamp column. This is a MySQL timestamp. Unfortunately, the MySQL server is 9 hours behind my time and I want to add 9 hours so it is right for me 🙂

I've found the MySQL function date_add() but I'm trying to get the "correct" date (as in my time) inserted in the first place. I'm not sure how to do this. This is currently my insert statement:

$result = mysql_query("INSERT INTO $table(ip, ip_range, page) VALUES('$ip', '$ip_range', '$page')");

The timestamp column comes after the "page" column. As you can see, I'm letting MySQL put the timestamp in.

I would be very greatful for any help that can help me to achieve what I want.

Thanks in advance 🙂

[rachel2004]

If you wish to do it all in the SQL statement, how about using the MySQL function now() (plus the 9 hours or whatever difference you're looking for?).

[Stu]

Works like a charm. Thanks very much 🙂