Subject | Re: [firebird-support] ISC_TIMESTAMP Issue |
---|---|
Author | Ivan Prenosil |
Post date | 2008-06-30T10:17:05Z |
> The table contains two time stamps: Start, End. These two values were input via FlameRobin as the following values: 'NOW' andDid you set tm_isdst to zero before calling isc_decode_timestamp() ?
> '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().
Ivan