puzzled about time_zone

prl prl at ozemail.com.au
Wed Apr 11 08:39:11 EDT 2012


It looks like the times are being stored in UTC. As they should be IMO. 
Local time has too many problems - that it's discontinuous and 
non-unique in the presence of daylight savings being a major one.

Peter

On 11/04/12 19:28, president ccj wrote:
>> 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.
>>
>>
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
>



More information about the gnucash-user mailing list