In Aqua Data Studio 14.0.0, I checked the option “Use iAnywhere Driver” for a Sybase IQ 15+ Server property to test the Bulk Import Feature.
The difference I can find using iAnywhere driver, is that while executing queries involving dates I now get a conversion error. For e.g
select * from orders where order_Date =’9/1/2013′
go
>[Error] Script lines: 1-2 ————————
[Sybase][JDBC Driver][Sybase IQ]Cannot convert ‘9/1/2013’ to a timestamp _
The order_Date is of date format. If I change ‘9/1/2013’ to ‘2013-09-01’, then the problem is gone. I have many codes using the format ‘9/1/2013’ and they works fine before my upgrade to ADS v14 using the iAnywhere Driver.
Are there some settings in ADS to make it work?
Response
Tariq Rahiman over 9 years ago
Execute the below command before you execute all your queries and you will be able to successfully execute remaining commands
set temporary option Date_order = ‘MDY’
To set this command for your connection with Sybase IAnwhere driver, edit your server properties and in the Scripts tab, enter the above script to be executed upon establishing a connection.