formatting date on output

[aquatsr]

I input the date a new record is added by using the NOW() function in MySQL. The problem is that the server time is 3 hours ahead of local time, and I want to display the dates using php in my timezone. How do I do that while still using NOW()Also, if I wanted to display the date in the user's local timezone, how would I do that?

[redsun]

You can take off any value you need, for example: (NOW() - 20).The number '20' depends on you database field data format (DATETIME, DATE, TIMESTAMP, TIME).

[aquatsr]

You can take off any value you need, for example: (NOW() - 20).The number '20' depends on you database field data format (DATETIME, DATE, TIMESTAMP, TIME).

OK. Say the field is DATE and I want to take off 3 hours?

[redsun]

Try to run this:

SELECT now() AS "current time"SELECT now()-30000 AS "current time minus 3 hours"

See the difference? I hope so ;o)