If you use the Sqlite floating point number format (function julianday
will do the conversion) you can use functions to compare days and dates.
Andre du Plessis wrote:
I have a UTC date stored in text column in this format:
2007-08-27 08:58:16.601000
I want to do some selects for all that is newer than one day for
example, or then all that is older than 1 month, etc,
Any ideas?
Thanks.
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
