This was really helpful. After looking at some other code I was able to get it working.

Thanks, Ivan.
Kurt.




----- Original Message ----
From: Ivan Prenosil <Ivan.Prenosil@...>
To: Firebird-Support <firebird-support@yahoogroups.com>
Sent: Monday, June 30, 2008 3:17:05 AM
Subject: Re: [firebird-support] ISC_TIMESTAMP Issue

> 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_timestam p().

Did you set tm_isdst to zero before calling isc_decode_timestam p() ?

Ivan






[Non-text portions of this message have been removed]