Results 1 to 2 of 2
  1. #1
    Join Date
    Jan 2004

    Unhappy 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,

    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 ...

  2. #2
    Join Date
    Feb 2005
    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

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts