Thank you again for all you work..
Giuliano
- Original Message -
From: "Ion Silvestru" <[EMAIL PROTECTED]>
To: "Giuliano" <sqlite-users@sqlite.org>
Sent: Friday, December 14, 2007 10:08 AM
Subject: Re[2]: [sqlite] Problems Insert with Date and Time
>It seems that "BETWEEN" in SQLite is treated as "BETWEEN..AND selects
>fields that are between and including the test values", so it can be
>used instead of ">=" and "<=".
I am sorry, but it seems I am partially correct.
I tested again and concluded:
1. "BETWEEN" in SQLite is treated as
It seems that "BETWEEN" in SQLite is treated as "BETWEEN..AND selects
fields that are between and including the test values", so it can be
used instead of ">=" and "<=".
-
To unsubscribe, send email to [EMAIL PROTECTED]
t; <[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
Hello,
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)
sorry, I am not be able at all to do that. Many thanks in advance for
helping,
Giuliano
5 matches
Mail list logo