Re: Re[2]: [sqlite] Problems Insert with Date and Time values

2007-12-14 Thread Giuliano
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

Re[3]: [sqlite] Problems Insert with Date and Time values

2007-12-14 Thread Ion Silvestru
>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

Re[2]: [sqlite] Problems Insert with Date and Time values

2007-12-14 Thread Ion Silvestru
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]

Re: [sqlite] Problems Insert with Date and Time values

2007-12-14 Thread Giuliano
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

[sqlite] Problems Insert with Date and Time values

2007-12-13 Thread Giuliano
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