I am fairly new to PHP and MySQL and currently working on a Content Management System for a company's website based in Singapore. But the site is hosted in the States.

My Question is how do I do a insert, update and select Mysql datetime showing Singapore's date and time rather than US date and time.

Would appreciate if anyone can enlighten me.

Thanks ahead

Chris