Hi, Iman.

I added the mktime(), and it is an hour off too.

At this point, I'm almost ready to code-scan FlameRobin or IBPP to figure out what they are doing differently...

Kurt.




----- Original Message ----
From: Iman S. H. Suyoto <ade@...>
To: firebird-support@yahoogroups.com
Sent: Sunday, June 29, 2008 4:49:32 PM
Subject: [firebird-support] Re: ISC_TIMESTAMP Issue


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_TIMESTAM P);
>
>
> bRetVal = StartQuery(STAT1, SQLDA1, szStatement, ErrorMsg );
> if( bRetVal == true )
> {
> if( 0 == isc_dsql_fetch( STAT1, &STMT1, 1, SQLDA1) )
> {
> // COPY THE RESULTS...
> isc_decode_timestam p(&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_timestam p() and isc_decode_timestam p().






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