22:24 AM
Subject: Re: Timestamps in Gnucash Mysql
Phil Longstaff writes:
> Also, sqlite does not have a datetime or timestamp but needs to use strings,
> and I've been coding mainly for sqlite, with mysql and pgsql taking 2nd place.
>
> Gnucash has both dates, and date-times.
Phil Longstaff writes:
> Also, sqlite does not have a datetime or timestamp but needs to use strings,
> and I've been coding mainly for sqlite, with mysql and pgsql taking 2nd place.
>
> Gnucash has both dates, and date-times. For dates, I can use CHAR(8) for
> sqlite, DATE for mysql and pgsql
On August 12, 2009 08:25:31 am Phil Longstaff wrote:
> On August 12, 2009 03:06:40 am marcus.wolsc...@googlemail.com 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
On August 12, 2009 03:06:40 am marcus.wolsc...@googlemail.com 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
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 full
___
gnucash-devel mailing list
gnucash-devel@gnucash.org
https://lists.gnucash.org/mailman/listinfo/gnucash-devel
imes it can even pop up behind the splash screen...
-derek
> -Original Message-
> From: Derek Atkins
> Sent: Wednesday, August 05, 2009 8:19 AM
> To: Kyle Creekmore
> Cc: gnucash-devel@gnucash.org
> Subject: Re: Gnucash & Mysql
>
> Hi,
>
> Kyle Creekmore writes:
Hi,
Kyle Creekmore writes:
> Hello,
>
> How can I incorporate this with mysql that has already been installed
> on my pc? When I try save as to the mysql it fails, but don't know
> exactly how to go about setting it up.
Just point GnuCash at your MySQL configuration when you choose the
MySQL c
Hello,
How can I incorporate this with mysql that has already been installed on
my pc? When I try save as to the mysql it fails, but don't know exactly
how to go about setting it up.
Thanks,
Kyle
___
gnucash-devel mailing list
gnucash-devel@gnucash
