MySql time problem

Hi,

I am using a shared hosting which has EST US time, since i am on shared hosting that’s why i cannot change the server time zone but i wanted to display local Pakistan time to my users. For example a user lists an item he/she wants to see at what time item was listed and they wanted to see it in Pakistan time not EST US time.

What’s the best solution to do this? Wanted to do it on database level…

Thanks
-Mannan

Use convert_tz to convert between time zones in a query.