"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 want to, considering that
date('1964-04-01') = '1964-04-01'. date() function produces a string in
YYYY-MM-DD format (the same format you are starting with). For more
details, see
http://www.sqlite.org/cvstrac/wiki?p=DateAndTimeFunctions
Igor Tandetnik
_______________________________________________
sqlite-users mailing list
sqlite-users@sqlite.org
http://sqlite.org:8080/cgi-bin/mailman/listinfo/sqlite-users
