[asterisk-users] func_odbc not returning whole smalldatetime MS Sql field.

[Jim DeVito]

Hey All,

Odd thing. I am just trying to return the whole date time stamp from a 
SMALLDATETIME field in a MS SQL server.

func_odbc.conf =  readsql=SELECT DateCreated FROM [REDACTED] WHERE Code 
= '${ARG1}'

Problem is I only get the first 15 back from the field. Like so...


Connected to Asterisk 1.8.6.0 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.

Any thoughts?

Thanks!!