Re: [sqlite] Sort by TIMESTAMP?

[Kurt Welgehausen]

> May try something like
>
> WHERE  julianday(DBTimeStamp) < julianday('2004/4/4')
> but I might be wrong.
>
> Lloyd

Or, you could read the docs:

  www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions

especially the section labeled 'Time Strings'.

Regards

---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]