NexusDB

Nexus (and FF) SQL want the date in yyyy-mm-dd format with a compulsary Date keyword.
Similarly for Time you need to use TIME'hh:mm:ss' for and Timestamp/Datetime you need to use TIMESTAMP'yyyy-mm-dd hh:mm:ss' formats.

Examples:

Select * from mytable where mydate = DATE'2002-11-24';
Select * from mytable where mytime = TIME'13:58:27';
Select * from mytable where mydate = TIMESTAMP'2002-11-24 13:58:27';