Subject Re: [firebird-support] ISC_TIMESTAMP Issue
Author Ivan Prenosil
> 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().

Did you set tm_isdst to zero before calling isc_decode_timestamp() ?

Ivan