How to handle the different timezone in mysql?

user login from india at 9:00 am other user from usa at other time.

how handle this if both the user having same server开发者_开发问答 but login from different timezone

You haven't really told us what your problem is, but the best way to handle multiple timezones is to always store your timestamps in UTC, and convert from local to UTC on insert, and from UTC to local for display.

You could store timezone offset for each user (make the user select one timezone when he creates the account) and do the transformations based on that