dates in SQLite format (2.3.11 for Windows)

am65 amarquez65 at yahoo.es
Thu Mar 25 16:05:00 EDT 2010


I would like to use the SQLite file from GnuCash to do some excel reporting.

But I found something strange. The dates in the log (in spanish it is "Libro
diario", I do not know how to translate it) sometimes do not match the dates
I get from the SQLIte file using this SQL:

select substr(t.post_date, 1, 8), t.description, a.code, a.name, s.value_num
from transactions t, accounts a, splits s
where t.guid = s.tx_guid
and a.guid = s.account_guid
order by t.post_date

In my case certain transactions made the first day of the month (as they
appear in the log) in the database have a POST_DATE of the last day of the
previous month, which is quite annoying when you are trying to do monthly
reporting.

As you can see I'm using the POST_DATE colum from TRANSACTIONS as the date.
I think that ENTER_DATE column is a timestamp of the row.

If I'm wrong, in which column of the SQLite database can I find the real
date of the transaction?
-- 
View this message in context: http://n4.nabble.com/dates-in-SQLite-format-2-3-11-for-Windows-tp1691216p1691216.html
Sent from the GnuCash - User mailing list archive at Nabble.com.


More information about the gnucash-user mailing list