dates in SQLite format (2.3.11 for Windows)

[am65]

Ok. Strange as it is that is a logical explanation.

I will check if there is a way to convert UTC to local time in SQLite.
Phil Longstaff wrote:
> 
> 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?
> 
> 
> _______________________________________________
> gnucash-user mailing list
> gnucash-user at gnucash.org
> https://lists.gnucash.org/mailman/listinfo/gnucash-user
> -----
> Please remember to CC this list on all your replies.
> You can do this by using Reply-To-List or Reply-All.
> 
> 

-- 
View this message in context: http://n4.nabble.com/dates-in-SQLite-format-2-3-11-for-Windows-tp1691216p1693510.html
Sent from the GnuCash - User mailing list archive at Nabble.com.