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]
