SQL Anywhere 17.0.10.6285: Date + Time field in remote proxy select statement

[fvestjens]

create variable aDate date;
create variable aTime time;
create variable aDateTime Datetime;

set aDate = current date;
set aTime = current time;
set aDateTime = aDate + aTime;

select aDate, aTime, aDateTime, *
from *remoteTable*

The propery aDateTime wil show the correct date time, but if you add aDate+aTime the system will give an error. This is because the space is removed between the date and time.

Is this the expected behaviour or a bug?

[VolkerBarth]

What remote DBMS are you using? When using proxy tables on MS SQL, querying for dates still fails for me, see here...

[chris_keating]

I have tried this with a proxy table for SQLA Demo Departments table and the following:

   create or replace variable aDate date;
   create or replace variable aTime time;
   create or replace variable aDateTime Datetime;

   set aDate = current date;
   set aTime = current time;
   set aDateTime = aDate + aTime;

  select 
     @@version, 
     aDate, aTime, aDateTime, 
    aDate + aTime, * 
  from departments 
  where DepartmentID = 100;

I get no errors.

It would helpful to know the remote server type and the specific error that is being reported.