May try something like
WHERE julianday(DBTimeStamp) < julianday('2004/4/4')
but I might be wrong.
Lloyd
----- Original Message -----
From: "Shawn Anderson" <[EMAIL PROTECTED]>
To: <[EMAIL PROTECTED]>
Sent: Tuesday, May 11, 2004 3:33 PM
Subject: RE: [sqlite] Sort by TIMESTAMP?
> You right, I should have tried it :)
>
> A couple of other things that I am noticing;
> - it seems that a col created with TIMESTAMP, is dropping all time
> information and only storing date values
> - I cannot narrow a select down using a TIMESTAMP col for example,
> neither of the follow have any effect:
> WHERE DBTimeStamp < '4/4/2004' or
> WHERE DBTimeStamp < '2004/4/4'
>
> I am trying to do something that is not possible with SQLite?
>
> Thanks
> Shawn
>
> -----Original Message-----
> From: Will Leshner [mailto:[EMAIL PROTECTED]
> Sent: Tuesday, May 11, 2004 10:23 AM
> To: Forum SQLite
> Subject: Re: [sqlite] Sort by TIMESTAMP?
>
>
> On May 11, 2004, at 7:17 AM, Shawn Anderson wrote:
>
> > Is it possible to do an ORDER BY on a col marked as TIMESTAMP and have
> > the order come back sorted correctly?
> >
>
> Sure. Try it out and see what happens.
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
>
> ---------------------------------------------------------------------
> To unsubscribe, e-mail: [EMAIL PROTECTED]
> For additional commands, e-mail: [EMAIL PROTECTED]
>
>
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
