Add thing. I am just trying to return the whole date time stamp from a SMALLDATETIME field in a MS SQL server.
Problem is I only get the first 15 back from the field. Like so…
Connected to Asterisk 184.108.40.206 currently running on [REDACTED]-dev (pid = 2240) Verbosity is at least 3 [REDACTED]-dev*CLI> odbc read ODBC_[REDACTED]-LOOKUP 104809 exec DateCreated 2011-12-19 13:2 Returned 1 row. Query executed on handle 0 [asterisk-mssql-connector]
Notice how it only returns “2011-12-19 13:2” and not the rest of the time… I have run the query on the SQL server and then from isql and it works everytime leaving the only abstraction point Asterisk.