https://bugs.freedesktop.org/show_bug.cgi?id=34309

--- Comment #5 from Terrence Enger <[email protected]> 2011-09-30 
14:26:01 PDT ---
Created an attachment (id=51813)
 View: https://bugs.freedesktop.org/attachment.cgi?id=51813
 Review: https://bugs.freedesktop.org/review?bug=34309&attachment=51813

OResultSet::getTimestamp to get it as string first

First, I have tried Caolán's patch from 2011-08-08 against both IBM i
and PostgreSQL, and it appears to fix the problem.

Second ...

"Data Management: SQL Call Level Interface", X/Open Company Ltd.,
1995.  in section "4.8.4 Transfers and Conversions > Transfers with
Conversion to/from String"
<https://www2.opengroup.org/ogsys/publications/viewDocument.html?publicationid=11216&documentid=10812>,
page 62, says 

    C programs must specify SQL_CHAR, forcing string conversion, for
    SQL data types ... TIMESTAMP ... because there is no direct
    equivalent for DECIMAL and NUMERIC in C."

I have made this work with the same two databases.  I attach a patch
for this, but I do not suggest that it would be good to do it this
ugly way.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
http://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs

Reply via email to