var sidebar_align = 'right';
var content_container_margin = parseInt('290px');
var sidebar_width = parseInt('270px');
Unanswered: Lotus NotesSQL 3.0.2e ODBC Driver Queries
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,
[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 ...
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: