I have never used Simba DB before... however my boss needs me to do integration between Simba DB and our system.
I just want to see the syntax of Simba SQL. However I can get no result on internet.
I just want to know two syntax.
One. Type conversion statement
select convert(StartDate, varchar)) from MyTable
where StartDate is Date
type. I want to convert to char or varchar. But I got
System.Data.Odbc.Odb开发者_运维知识库cException (0x80131937): ERROR [42000] [Simba][SimbaEngine ODBC Driver]The second parameter varchar for CONVERT is invalid.
Two. Inner sql statement
select * from (select * from MyTable)
This syntax is totally failed.
Please help...orz...
Alex
You can find documentation here: http://www.simba.com/odbc-sdk-documents.htm
I struggled with this as well... Got following examples from a Simba contact:
select convert(DATE_COL1, SQL_VARCHAR) from Date
select convert('2011-04-01', SQL_TYPE_TIMESTAMP)
select convert('2011-04-01', SQL_TYPE_DATE)
Which i could apply successfully!
精彩评论