Conversion of SQL_TEXT / SQL_VARCHAR to SQL_TIMESTAMP / SQL_TYPE_TIME / SQL_TYPE_DATE [CORE2066] #2502 Closed firebird-automations opened this issue on Sep 5, 2008 · 10 comments Collaborator ...

fn_varbintohexstr is an undocumented function best avoided In the convert examples, changing the 1 to 2 omits the 0x.

SQL Server has many different ways (column types) to represent date/time values, and depending on which one is used in the database table, you may have some surprising results when trying to consume ...