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