<br><br><div class="gmail_quote">On Mon, Jul 5, 2010 at 10:26 PM, Fernando Vilas <span dir="ltr"><<a href="mailto:fvilas@iname.com">fvilas@iname.com</a>></span> wrote:<br><blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<div class="im">On Monday, July 05, 2010 20:53:02 Brian Cappello wrote:<br>
> SVN commit 1146441 by bcappello:<br>
><br>
> first working attempt at bind variables<br>
><br>
> M +9 -4 backend.cpp<br>
> M +52 -48 statsmanager.cpp<br>
><br>
</div>[...]<br>
<div class="im">> // <a href="http://results.at" target="_blank">results.at</a>( indexOf(date) ) looks like 'MM/DD/YYYY' but we want<br>
> 'YYYY-MM-DD' [or maybe DD-MM-YYYY?] @@ -379,7 +391,7 @@<br>
> results[i] = tmp.join("-");<br>
> }<br>
<br>
</div>Brian,<br>
<br>
It looks like you are making good progress on the bind variables.<br>
<br>
I happened to see the above line in the diff, even though it was not part<br>
of the changes. In KMM, we are using Qt::ISODate to set the date format for<br>
storage, to get around any locale differences. For anything presented to the<br>
user, we use the locale settings, but in storage we went for consistency. If<br>
that helps, great; if not, at least you have some extra info.<br></blockquote><div><br>Hi Fernando,<br>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 :) </div>
<blockquote class="gmail_quote" style="margin: 0pt 0pt 0pt 0.8ex; border-left: 1px solid rgb(204, 204, 204); padding-left: 1ex;">
<font color="#888888"><br>
--<br>
Thanks,<br>
Fernando Vilas<br>
<a href="mailto:fvilas@iname.com">fvilas@iname.com</a><br>
</font><br>_______________________________________________<br>
Kde-finance-apps mailing list<br>
<a href="mailto:Kde-finance-apps@kde.org">Kde-finance-apps@kde.org</a><br>
<a href="https://mail.kde.org/mailman/listinfo/kde-finance-apps" target="_blank">https://mail.kde.org/mailman/listinfo/kde-finance-apps</a><br>
<br></blockquote></div><br>