temp table to view current datetime

[lsabster]

Is there a temp table to view current datetime like DUAL in Oracle?

Thank you.

[Richard]

Is there a temp table to view current datetime like DUAL in Oracle?

Attunity Connect does not have a temp table to view current datetime but it does have many built-in functions that can be used with a RMS data source, the following SQL with an RMS data source would return the current date and time.

select current_time(),c_name from myRMS_navdemo:customer

Please check the help files for a full list of functions.