Where is Simba DB SQL Reference?

▲
0
▼

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.OdbcException (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

sql
syntax
asked on Stack Overflow Aug 30, 2011 by Alex Yeung

2 Answers

▲
1
▼

You can find documentation here: http://www.simba.com/odbc-sdk-documents.htm

answered on Stack Overflow Aug 30, 2011 by Derek Kromm
▲
0
▼

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!

answered on Stack Overflow Apr 12, 2018 by oae

User contributions licensed under CC BY-SA 3.0