dates in SQLite format (2.3.11 for Windows)

[Phil Longstaff]

The problem is that the dates are stored in UTC, not local time.  There
have been *long* discussions about this.

Phil

On Thu, 2010-03-25 at 12:05 -0800, am65 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?