On August 12, 2009 03:06:40 am [email protected] wrote: > 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.)
That goes back to the time when the sql backend couldn't support different SQL/DDL code for the different db engines. There is no SQL standard for a date/time that all 3 db's (sqlite3/mysql/pgsql) share. Now that the sql backend can support different column types for the 3 dbs, it does make sense to use the proper types. Phil _______________________________________________ gnucash-devel mailing list [email protected] https://lists.gnucash.org/mailman/listinfo/gnucash-devel
