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" Sent: Friday, December 14, 2007 10:08 AM Subject: Re[2]: [sqlite] Problems Insert with Date and Time values It seems that "B

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[2]: [sqlite] Problems Insert with Date and Time values

2007-12-14 Thread Ion Silvestru
I avoided "BETWEEN" because this operator is treated differently in different databases, and I don't tested how it is treated in SQLite. http://www.w3schools.com/sql/sql_between.asp - To unsubscribe, send email to [EMAIL