Select Max(TheDate+TheTme) geht nicht

[omata]

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