Thanks a lot!
any suggestion for a query then that read and compare dates, for ex.:
SELECT somefiled FROM sometable WHERE datefield1 BETWEEN ' '? AND ' '?
How can I query then the string values as date?
Thanks again
Giuliano
----- Original Message -----
From: "Ion Silvestru" <[EMAIL PROTECTED]>
To: "Giuliano" <sqlite-users@sqlite.org>
Sent: Friday, December 14, 2007 8:55 AM
Subject: Re: [sqlite] Problems Insert with Date and Time values
>is it possible (how?) to insert into 2 different fields (date) the
>following
values:
09:30:00 (only a time value...)
14/07/07 (only year value, 14th of december 2007)
Just store date and/or time as string: "20070714" or "070714",
"093000". It is compact, you can sort them easily etc. You can store
them also as Integer: 20070714, 93000, this will save space in
database, as integers are stored in variable-length format (VarInt).
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------
-----------------------------------------------------------------------------
To unsubscribe, send email to [EMAIL PROTECTED]
-----------------------------------------------------------------------------