Re: [sqlite] how to insert and select a date column

2007-03-01 Thread Dennis Cote
Rafi Cohen wrote: Just another small question to complete this subject: in case of prepared insert statements, assuming the date is stored as string as in your example, do I use sqlite3_bind_text with a variable pointing to a string containing the date I want to insert? In other words, is this a

RE: [sqlite] how to insert and select a date column

2007-03-01 Thread Rafi Cohen
To: sqlite-users@sqlite.org Subject: Re: [sqlite] how to insert and select a date column Rafi Cohen wrote: > > Hi, I apologize in advance for the probably very basic question as I'm > a newbie to sqlite and integrating sql in C applications. One of my > tables in my databas

Re: [sqlite] how to insert and select a date column

2007-02-28 Thread Dennis Cote
Rafi Cohen wrote: Hi, I apologize in advance for the probably very basic question as I'm a newbie to sqlite and integrating sql in C applications. One of my tables in my database requires a date column. I understand from a tutorial not related to C/C++ api that insering date columns is not triv

[sqlite] how to insert and select a date column

2007-02-27 Thread Rafi Cohen
Hi, I apologize in advance for the probably very basic question as I'm a newbie to sqlite and integrating sql in C applications. One of my tables in my database requires a date column. I understand from a tutorial not related to C/C++ api that insering date columns is not trivial and triggers nee