Lotus NotesSQL 3.0.2e ODBC Driver Queries

[fk3qsz]

hi all DBForum,

I have installed Lotus NotesSQL 3.0.2e, I think with NotesSQL SQL query is different, I want to query with DATE , ie greater than or equal to this date. My date format is '06/01/2002 17:00:00'

SELECT SrvDT FROM ge2 WHERE SrvDT > '06/01/2002 17:00:00'

When I qery, I get error,

ODBC--call failed.
[Lotus][ODBC Lotus Notes]Data Value is not a valid date, time or timestamp

what is wrong with this query or how can I do this ?

NotesSQL SQL query is different ? How can I get any help, website or document ?

Thanks all for any help ...

[eX3000]

May be this could help

WHERE clause and TIMESTAMP fields: Timestamp fields need to be
fully padded when used in WHERE clauses if the time component is not
used. That is, if time is not used, the following format is required:
“1995-12-31 00:00:00”