Hi Simon,
That is what I tried to do in my query examples that I included in the
original message. Based on those, would you say that I am doing it
correctly?
Kind regards,
Philip Bennefall
On 8/9/2014 11:49 PM, Simon Slavin wrote:
On 9 Aug 2014, at 9:53pm, Philip Bennefall <phi...@blastbay.com> wrote:
Is it safe to rely on the conversion between the floating point julianday and
the date string being accurate if the date is in fact valid?
Probably not. The safest thing is to turn the string into a number (probably
Julian day or epoch) and then turn it back into a date again. If you get the
original string back, it's a legit date. If you get something else, it might
be something like the 30th of February.
Simon.
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
