Hi,
I have found a strange thing trying to create my report with SQL queries
from Postgresql Gnucash database.
The column post_date in transactions table stores values in timestamp
format (YYYY-MM-DD hh:mm:ss).
If I compare the post date in the transaction inside Gnucash program and
in Postgresql database, I see this:
Gnucash program Postgresql DB
31/12/2017 2017-12-31 00:00:00
31/12/2017 2017-12-31 10:59:00
01/01/2018 2017-12-31 22:00:00
---------------------------------------------------------------
02/01/2018 2018-01-01 22:00:00
02/01/2018 2018-01-02 10:59:00
--------------------------------------------------------------
31/12/2018 2018-12-30 22:00:00
31/12/2018 2018-12-31 10:59:00
So, the same dates in DB can be different dates in Gnucash program and
vise versa.
There are only 00:00:00, 10:59:00, 21:00:00, 22:00:00 values of time.
Please explain how this mystics work and what is the reason to save
dates like this...
I cannot make my reports without correct converting of dates.
Regards,
Dimon.
_______________________________________________
gnucash-user mailing list
[email protected]
To update your subscription preferences or to unsubscribe:
https://lists.gnucash.org/mailman/listinfo/gnucash-user
If you are using Nabble or Gmane, please see
https://wiki.gnucash.org/wiki/Mailing_Lists for more information.
-----
Please remember to CC this list on all your replies.
You can do this by using Reply-To-List or Reply-All.
