Joerg Krueger 19.Feb.04 01:36 PM a Web browser Lotus ConnectorsLC LSX - All ReleasesWindows NT
hi all,
we store(with german notes 6.03) appointments via lc lsx into a db2-table.
the db2-table entries of startdatetime or enddatetime differ from the notes-document. actually, db2 stores a notes dt-value, i.e. 13:00:00 as 12:59:59. this leads to confusion, if you present these wrong values to the user. unfortunately you cannot predict if this weird thing affects to only startdate- or only enddatetime or not at all. it seems to happen without a rule.
in notes we are using the LC_DATETIME for appending the value to a LC_FIELDLIST. we insert the fieldlist with the lc_connection.insert method.
In DB2, the field-type specified is TIMESTAMP.
Any other experiences with this problem or probably any solutions ?
any help would be very helpful.
Return to top
DateTime-Values stored wrong in DB2... (Joerg Krueger 19.Feb.04)
. . 
Print this page
