Melanie Hoch 23.Nov.10 05:11 PM a Web browser LC LSX LC LSX - All Releases All Platforms
I am using LC LSX to transfer a time value from a Lotus Notes application to a DB2 table. For some time values, they are converted inaccurately when transferring them to DB2. For example, if 8:30 AM is the value of my time field in my Lotus Notes application, the value transferred is 08:29:59 rather than 08:30:00. Likewise, 2:00 PM is transferred as 13:59:59 rather than 14:00:00. Other times such as 9:30 AM are transferred correctly as 09:30:00.
I have added a trace statement in my db2cli.ini file and can see that this conversion is happening on the Notes client as it transfers the data.
I have tried adding the following statement in my db2cli.ini file, but it didn't have any effect:
Does anyone have any idea what may be causing this and what can be done to make it transfer the time correctly?