Timezone

[omartare]

How can i change mysql time zone to record the data coming

[Krydos]

By default mysql uses the server's timezone, which is set to UTC. Depending on your scripting language it's probably easier to set the timezone before you do your queries. For instance in php you could use

date_default_timezone_set("America/Los_Angeles");

You can also change the timezone in your raw mysql queries by using convert_tz

select thing, convert_tz(timestamp, @@session.time_zone, '-08:00') from stuff;