Wrong Timestamp conversion from client API
------------------------------------------

                 Key: CORE-3670
                 URL: http://tracker.firebirdsql.org/browse/CORE-3670
             Project: Firebird Core
          Issue Type: Bug
          Components: API / Client Library
    Affects Versions: 2.5.0
         Environment: Ubuntu  10.04
            Reporter: Lars Liedtke


When I call the Timestamp conversion functions I have to do this:
WINEXPORT void decodeTimestamp(TIMESTAMP* timestamp, struct tm* tm)
{
        // error correction in timestamp calculation of Firebird 2.5
        timestamp->timestamp_date = timestamp->timestamp_date + Dec31_1899;
        isc_decode_timestamp(timestamp, tm);
}

WINEXPORT void encodeTimestamp(struct tm* tm, TIMESTAMP* timestamp)
{
        isc_encode_timestamp(tm, timestamp);
        // error correction in timestamp calculation of Firebird 2.5
        timestamp->timestamp_date = timestamp->timestamp_date - Dec31_1899;
}

Dec31_1899 is a const declared like this:
const int Dec31_1899 = 693960;



-- 
This message is automatically generated by JIRA.
-
If you think it was sent incorrectly contact one of the administrators: 
http://tracker.firebirdsql.org/secure/Administrators.jspa
-
For more information on JIRA, see: http://www.atlassian.com/software/jira

        

------------------------------------------------------------------------------
All the data continuously generated in your IT infrastructure 
contains a definitive record of customers, application performance, 
security threats, fraudulent activity, and more. Splunk takes this 
data and makes sense of it. IT sense. And common sense.
http://p.sf.net/sfu/splunk-novd2d
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to