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? > 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] --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
