Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

 All Forums
 Other Forums
 Other Topics
 CONVERT and odbc text driver

Author  Topic 

AskSQLTeam
Ask SQLTeam Question

0 Posts

Posted - 2001-02-02 : 11:53:17
scott writes "i am using a simple setup...

SELECT convert(varchar,DateFieldName,101) as USDateFormat FROM TableName

and i have tested an equivalent setup within the query analyzer which does work.

But.. i get this error when using the text driver of odbc:

[microsoft][odbc text driver] undefined function 'convert' in expression.

i have looked thru the doco on the text driver and also for convert, but have come up dry. any suggestions?"
   

- Advertisement -