Very nice: Identify a date format.
*Anybody else?
*-R.*
*
Andrew Finkenstadt wrote in part:
8><
and we select the date_format column based on the likeness of the
date_pattern column, run it through to_date, catch any exceptions, and
return the DATE column.
--a
-
Create a column with DATE type and Sqlite will make it numeric affinity.
Store the date in Sqlite format using the date functions julianday,
datetime etc. You can use the strftime function for special date
formatting.
Sqlite has functions to go from ISO8601 date format to the internal date
Daniel Cohen Gindi wrote:
Hi guys!
Is there any way to make SQL queries, with the WHERE clause containing
dates? I mean [WHERE col > 05/12/2007] or such?
It just that I have noticed that there's no DATE datatype.
If there's no way, is it easy to override the text comparing operators (<=,
The sqlite3_prepare API call compiles the SQL to a target code called
VDBE. The VDBE code is executed by the Sqlite VDBE engine. Once
compiled the VDBE may e reused.
Mina R Waheeb wrote:
Hi,
Yes, You are right. How SQLite will know the position of the row 990
unless it ordered by indexed f
In oracle there is the TO_DATE function which accepts at least two
arguments: a field convertible to string, and a string defining the date
format of the first field. This format string involves portions of date
strings like '-MM-DD HH24:MI:SS' , our standard sortable no-timezone
date format
I'm not claiming to have invented anything new, as I was using similar
techniques some 30 years ago in another life (in the employ of a large
blue company which shall remain nameless :-[ ). Not in SQL, you
understand. A pretty thorough search didn't turn up any such use in
online SQL documentat
On 8/19/07, Igor Tandetnik <[EMAIL PROTECTED]> wrote:
> http://archives.devshed.com/forums/showpost.php?p=5772144&postcount=8
I've seen some interesting things out of web forums and mailing list
gateways, but having all of the capital 'O's go missing is a new
one...
http://www.mail-archive.com/s
Mina R Waheeb <[EMAIL PROTECTED]> wrote:
So, I have two questions about that mechanism of executing the quires:
- What is the language type that's the code generator is generating?
http://sqlite.org/vdbe.html
http://sqlite.org/opcode.html
- Can i skip the SQL parsing and provide ready compile
Hi John,
> Folks are dumb where I come from; can someone please explain how this
> could be correct?
I don't know where you come from, so I can't help you.
:-)
sorry,
Simon
-
To unsubscribe, send email to [EMAIL PROTECT
We've used this exact technique in a table called "ANY_DATE_FORMAT" since
1997... admittedly in Oracle, but the principle still applies.
It's great for coalescing the number of states necessary to implement
parsers. :)
--andy
On 8/18/07, Rod Dav4is <[EMAIL PROTECTED]> wrote:
>
> Conventional us
Well I have just made some tests with strcmp() and _tcscmp(), and they do
the job, and according to the documentation, it uses strcmp() to compare
TEXT fields...
OK, I'm fine now! :-D
-Original Message-
From: Chris Peachment [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 19, 2007 2:25 PM
Why don't you try it and see?
Use the sqlite3 command line interpreter
with the a sample database.
On Sun, 19 Aug 2007 13:28:20 +0200, Daniel Cohen Gindi wrote:
>Can I create a table with DATE datatype? Or just use text datatype with
>-mm-dd?
>I can see that sorting will be easy with just
Can I create a table with DATE datatype? Or just use text datatype with
-mm-dd?
I can see that sorting will be easy with just text -mm-dd,
But what about BETWEEN or > mailto:[EMAIL PROTECTED]
Sent: Sunday, August 19, 2007 12:19 PM
To: sqlite-users@sqlite.org
Subject: Re: [sqlite] Making
Use the ISO date format mmdd or -mm-dd
and your sort and search problems disappear.
On Sun, 19 Aug 2007 12:16:41 +0200, Daniel Cohen Gindi wrote:
>Hi guys!
>
>Is there any way to make SQL queries, with the WHERE clause containing
>dates? I mean [WHERE col > 05/12/2007] or such?
>It ju
Hi guys!
Is there any way to make SQL queries, with the WHERE clause containing
dates? I mean [WHERE col > 05/12/2007] or such?
It just that I have noticed that there's no DATE datatype.
If there's no way, is it easy to override the text comparing operators (<=,
>=, <, >) ?
Thanks a lot!
OK, got it solved.
Just changed the generated Makefile manually, and bypassed the configure
script.
Thanks for the help. Nir.
-Original Message-
From: Rachmel, Nir (Nir) [mailto:[EMAIL PROTECTED]
Sent: Sunday, August 19, 2007 11:01 AM
To: sqlite-users@sqlite.org
Subject: RE: [sqlite] S
Yes, I do. That's how it worked for sqlite 3.2.8.
I am cross compiling from i686 to a ppc based system, and I tried
pointing the directories where these libs reside via the configure:
--with-readline-lib="..."
--with-readline-inc="..."
But to no avail. I get an error message from the Makefile:
/h
17 matches
Mail list logo