Where is Simba DB SQL Reference?

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!