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? |
What remote DBMS are you using? When using proxy tables on MS SQL, querying for dates still fails for me, see here...
I have tried this with a proxy table for SQLA Demo Departments table and the following:
I get no errors.
It would helpful to know the remote server type and the specific error that is being reported.