dotnet odbc.net: Does anyone know what date formats ODBC.Net expects dates to be in? I'm used to converting dates to {d'yyyy-mm-dd'} in my insert and update statements. This no longer works. DateTimes required {ts'yyyy-mm-dd hh-mm-ss'}

Do you know where I look up this ODBC.Net SQL Syntax like this? Lists of ODBC functions that work under ODBC.Net would be useful as well

Thanks very muc

try this http://support.microsoft.com/?kbid=230912
might help

[quoted text, click to view]
used to converting dates to {d'yyyy-mm-dd'} in my insert and update
statements. This no longer works. DateTimes required {ts'yyyy-mm-dd
hh-mm-ss'}.
[quoted text, click to view]