dates in SQLite format (2.3.11 for Windows)

[Colin Law]

On 25 March 2010 20:05, am65 <amarquez65 at yahoo.es> wrote:
>
> 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?

When you have read it in convert it to local time and all will be well.

Colin L