Hi Kurt,

--- In firebird-support@yahoogroups.com, Kurt Federspiel
<federonline@...> wrote:

>
> A code snippet looks like this:
>
> SQLDA1->sqlvar[7].sqldata = (char *) &iscTimeStamp;
> SQLDA1->sqlvar[7].sqltype = SQL_TIMESTAMP;
> SQLDA1->sqlvar[7].sqllen = sizeof(ISC_TIMESTAMP);
>
>
> bRetVal = StartQuery(STAT1, SQLDA1, szStatement, ErrorMsg );
> if( bRetVal == true )
> {
> if( 0 == isc_dsql_fetch(STAT1, &STMT1, 1, SQLDA1) )
> {
> // COPY THE RESULTS...
> isc_decode_timestamp(&iscTimeStamp, &DateTime_Stamp);

I'm curious. What if you add:

mktime(&DateTime_Stamp);

here?

Like what Lester mentioned, there's no daylight saving/time zone
conversion done by isc_encode_timestamp() and isc_decode_timestamp().