Re: [sqlite] How to use function in binding parameters ?

Marten Feldtmann <[EMAIL PROTECTED]> wrote: > Igor Tandetnik wrote: >> It's not clear why you would want to, considering that >> date('1964-04-01') = '1964-04-01'. date() function produces a string >> in -MM-DD format (the same format you are starting with). > > Due to a totally

Re: [sqlite] How to use function in binding parameters ?

Igor Tandetnik wrote: > It's not clear why you would want to, considering that > date('1964-04-01') = '1964-04-01'. date() function produces a string in > -MM-DD format (the same format you are starting with). Due to a totally misunderstanding of these functions ... forget my question

Re: [sqlite] How to use function in binding parameters ?

"Marten Feldtmann" <[EMAIL PROTECTED]> wrote in message news:[EMAIL PROTECTED] > I'm not sure how to use a function call in a prepared statement: > > insert into persons(name, birthday) values( ?,?) > > how to I bind the value of date('1964-04-01') to one of the > parameters ? It's not clear why

Re: [sqlite] How to use function in binding parameters ?

Hello Marten, do this: insert into persons(name, birthday) values( ?, date(?)) And bind the string '1964-04-01' Martin Marten Feldtmann schrieb: > I'm not sure how to use a function call in a prepared statement: > > insert into persons(name, birthday) values( ?,?) > > how to I bind the value

[sqlite] How to use function in binding parameters ?

I'm not sure how to use a function call in a prepared statement: insert into persons(name, birthday) values( ?,?) how to I bind the value of date('1964-04-01') to one of the parameters ? I want to store not the string, but the value of the internal date-function-call into that column ? Somehow