So geht es auch im Dialect 1...
SQL-Code:
SELECT MAX(CAST(EXTRACT(YEAR FROM TheDate) || '-' ||
EXTRACT(MONTH FROM TheDate) || '-' ||
EXTRACT(DAY FROM TheDate) || ' ' ||
EXTRACT(HOUR FROM TheTime) || ':' ||
EXTRACT(MINUTE FROM TheTime) || ':' ||
EXTRACT(SECOND FROM TheTime) AS TIMESTAMP))
FROM table