[GNC] Date Fields

Robin Chattopadhyay robinraymn at gmail.com
Sun Apr 29 21:24:00 EDT 2018


I use SQLite to create some basic reporting from gnucash and I noticed that
after upgrading from 2.6.x to 3.0/3.1 several of the date fields are now
stored in two different formats:

Transactions entered in the file under 2.6.x are: yyyymmddhhmmss while
dates entered in the file under 3.0/3/1 are yyyy-mm-dd hh:mm:ss.

Is this by design? I worked around it by adding a CASE statement to the sql
I was using.

Robin


More information about the gnucash-user mailing list