RE: [sqlite] Sort by TIMESTAMP?

2004-05-11 Thread Shawn Anderson
On draw back to these is that they are pretty much non portable to other RDBMS. But they look good... Shawn -Original Message- From: Kurt Welgehausen [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 11:50 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Sort by TIMESTAMP? >

RE: [sqlite] Sort by TIMESTAMP?

2004-05-11 Thread Shawn Anderson
I'll give it a try, thanks :) -Original Message- From: Lloyd thomas [mailto:[EMAIL PROTECTED] Sent: Tuesday, May 11, 2004 10:54 AM To: [EMAIL PROTECTED] Subject: Re: [sqlite] Sort by TIMESTAMP? May try something like WHERE julianday(DBTimeStamp) < julianday('2004/4/4

Re: [sqlite] Sort by TIMESTAMP?

2004-05-11 Thread 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

Re: [sqlite] Sort by TIMESTAMP?

2004-05-11 Thread Lloyd thomas
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]

RE: [sqlite] Sort by TIMESTAMP?

2004-05-11 Thread Shawn Anderson
ED] 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? > Su

Re: [sqlite] Sort by TIMESTAMP?

2004-05-11 Thread Will Leshner
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: [E