The SitePoint Forums have moved.

You can now find them here.
This forum is now closed to new posts, but you can browse existing content.
You can find out more information about the move and how to open a new account (if necessary) here.
If you get stuck you can get support by emailing forums@sitepoint.com

If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

'Changing' The Time Entered Into Database

Hello,

My server is the in the Eastern (USA) timezone, so when things are entered into the database (e.g., mysql_query("insert into myTbl (time_entered) VALUES ('".time()."')")), it obvious enters it in as the EST timezone. Would '".time()-10800."' (10800 seconds = 3 hours) change it to the Pacific TZ, because they are 3 hours behind EST timezone? Does it work this way, or is there any other easier way to do this?

If you are going to have different users wanting to see time in their own time zone I'd store the times in the DB as GMT 0, and then perform the offsets at display.

If you want all the times to be set to your time zone then I'd translate them at insertion time.
Also - I'd store your time zone offset (the 10800 seconds) in a central include somewhere, because you don't know when the time on the server (shared I assume) might change.