#98 IQL does not support SQL:2003 standard datetime literals

[Steven Mitchell]

Wina Jansen reported (support ng: 15 May 2006):

I used to have a SELECT statement such as:

SELECT * FROM Table WHERE datetime < "2006-01-01 00:00:00"

It worked fine with the old database (Nexus1.08).
However latest SQL:2003 compliance of new database
(Nexus2) requires a comparison such as:

SELECT * FROM Table WHERE datetime < DATETIME
"2006-01-01 00:00:00"

I get the message from TInstantIQLObject that token
"2006-01-01 00:00:00" is invalid.
However it should not expect a token after DATETIME.
It withholds the statement from being send to the database.
Is there any escape?

*** -----------

An unofficial patch has been proposed as a work around.
See response to the above report in support ng.