[Kde-finance-apps] playground/office/alkimia/alkquotes/backend

[Brian Cappello]

On Mon, Jul 5, 2010 at 10:26 PM, Fernando Vilas <fvilas at iname.com> wrote:

> On Monday, July 05, 2010 20:53:02 Brian Cappello wrote:
> > SVN commit 1146441 by bcappello:
> >
> > first working attempt at bind variables
> >
> >  M  +9 -4      backend.cpp
> >  M  +52 -48    statsmanager.cpp
> >
> [...]
> >     // results.at( indexOf(date) ) looks like 'MM/DD/YYYY' but we want
> > 'YYYY-MM-DD' [or maybe DD-MM-YYYY?] @@ -379,7 +391,7 @@
> >     results[i] = tmp.join("-");
> >        }
>
> Brian,
>
>        It looks like you are making good progress on the bind variables.
>
>        I happened to see the above line in the diff, even though it was not
> part
> of the changes. In KMM, we are using Qt::ISODate to set the date format for
> storage, to get around any locale differences. For anything presented to
> the
> user, we use the locale settings, but in storage we went for consistency.
> If
> that helps, great; if not, at least you have some extra info.
>

Hi Fernando,
Upon further research it seems like YYYY-MM-DD is the format Qt::ISODate
defaults to, as well as how SQLite date-related-functions expect dates to be
stored, so for simplicity's sake I think I like your advice to just go with
consistency for the storage of dates hard-coded to this format. Thanks for
the feedback :)

>
> --
> Thanks,
> Fernando Vilas
> fvilas at iname.com
>
> _______________________________________________
> Kde-finance-apps mailing list
> Kde-finance-apps at kde.org
> https://mail.kde.org/mailman/listinfo/kde-finance-apps
>
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: http://mail.kde.org/pipermail/kde-finance-apps/attachments/20100706/76e89dbd/attachment.htm