puzzled about time_zone

[president ccj]

> Hi,
> I use Mysql to store data when using  gnucash ,and I find the field
>  post_date and end_date  of transactions table are  8 hours less  than it
> seems to be.

eg.SELECT  guid,post_date,enter_date  from transactions;
>
> f7f36298716f8ec016ed67e2441b4cac  2012-02-28 16:00:00 2012-04-10 01:49:13
>
> but the post_date and enter_date should be 2012-02-29 and 2012-04-10
> 09:49:13
>
> and mysql time_zone is set to '+8:00'.
>
>
>                                                                  thanks.
>
>