Author Kurt Federspiel

I have an application that is attempting to do a time-weighted average of data, but I am having an issue with Time Stamps. This application was working on WinXP/FB 2.03. I am porting it to Linux (Ubuntu)/FB 2.1.

The table contains two time stamps: Start, End. These two values were input via FlameRobin as the following values: 'NOW' and '2008-06-27 17:00:00'

If I select on the table using FlameRobin, I get the correct time ('2008-06-27 15:02:33' and '2008-06-27 17:00:00').

However, my application returns the time an hour off (with the following debug info):
trend_main.h:144 Start: 2008-06-27 16:03:33
trend_main.h:160 Stop: 2008-06-27 18:00:00

When I pull the ISC_TIMESTAMP from the DB, I convert it to a struct tm using isc_decode_timestamp().

Is there something I am doing wrong or is there another method to compute the time stamp from the DB??