Timestamps in Gnucash Mysql

marcus.wolschon at googlemail.com marcus.wolschon at googlemail.com
Wed Aug 12 03:06:40 EDT 2009

I just found out that gnucash stores
DatePosted and DateEntered as Strings
instead of the proper DateTime or Timestamp
sql data-types.

Why is that? In XML it already uses a proper

This makes is very hard to sort by date in
SQL-queries and to select a range as you need
a complex fulltext-index instead of a trivial
integer index. (There are supposed to be MANY
transactions and splits in there.)


More information about the gnucash-devel mailing list