Getting Date From DB Changin Hour

[planetsim]

Ok im probably trying a little too hard on this, and probably looking for a really hard way around what i require to do.

Ok
I can get a date without the database and add subtract how ever many hours i need to like so

gmdate("h:i:sa", strtotime("$r[timezone] Hour")); $r[timezone] could be -10 etc

So it would output different times. Just like this board does.
Now thats easy.

Now what i want to do is similar to that except im now pulling the date out of the database which is in the datetime format.

Ive tried the way i did it before. But im assuming as im getting the date from the database as a variable its not able to get the hour.

Now i think i need to use the dateformat but ive tried that so i could be doing something wrong there. To get the hour to added or subtracted.

Sorry if this sounds like absolute rubbish. Im getting very tired.

[xblue]

did you look into mysql's date_add function? might be useful.
assuming $timezone holds the offset e.g.

SELECT DATE_ADD(date, INTERVAL $timezone HOUR) AS localdate FROM TABLE

or, when you want to format it e.g.:

SELECT DATE_FORMAT(DATE_ADD(date, INTERVAL $timezone HOUR), '%W %M %Y - %H:%i:%s') AS localdate FROM TABLE

or did I get you completely wrong?

[planetsim]

Actually after posting this. I remembered that, so i went to the mysql docs. Im not sure if i did it right though. But oh well ill probably try again. Soon.

Thanks for the help to