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

[Igor Tandetnik]

"Marten Feldtmann" <[EMAIL PROTECTED]>
wrote in message [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