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 of
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
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 you would
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 I
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 misunderstanding of these