Need to display UK TimeZone instead of USA, i am using mysql Now() function

[kee2ka4]

Hello everyone,

 

I need some help with regards to displaying UK TimeZone. I save "user comments and the date and time created" into a MySql database. I use the Now() to save the date and time into the mysql databse. Since my hosting company is based in USA, when my page gets the time infomation from the database it shows the USA timezone, but I need to display the UK time. What do I need to change so I can display the correct UK time. Is there any function or any settings I need to change in the database or server?

 

Thanks,

Ket

[kee2ka4]

Does anyone know how I can solve this? Any guide or direction....

[PFMaBiSmAd]

See fenway's post in this thread where he links to the timezone section in the mysql manual.