Timestamps in Gnucash Mysql

[marcus.wolschon at googlemail.com]

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
date-format.

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.)

Marcus