[Libreoffice-bugs] [Bug 51779] New: support for SQL datatype INTERVAL

bugzilla-daemon at freedesktop.org bugzilla-daemon at freedesktop.org
Fri Jul 6 11:50:47 CEST 2012


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

             Bug #: 51779
           Summary: support for SQL datatype INTERVAL
    Classification: Unclassified
           Product: LibreOffice
           Version: 3.5.4 release
          Platform: All
        OS/Version: All
            Status: UNCONFIRMED
          Severity: enhancement
          Priority: medium
         Component: Database
        AssignedTo: libreoffice-bugs at lists.freedesktop.org
        ReportedBy: lionel at mamane.lu
                CC: cno at nouenoff.nl, cwiek at home.nl, iplaw67 at yahoo.co.uk,
                    lionel at mamane.lu
        Depends on: 51523


+++ This bug was initially created as a clone of Bug #51523 +++

LibreOffice does not support the SQL INTERVAL datatype. That is the datatype to
store time *durations*, rather than a point in time (like DATE, TIME,
TIMESTAMP).

Our embedded HSQLDB 1.8 also does not support it, but that is no reason not to
support it cleanly when connecting to database backends that *do* support it.

Places that need to be changed:

1) offapi/com/sun/star/sdbc/DataType.idl needs a value for INTERVAL

2) connectivity/inc/connectivity/FValue.hxx: class ORowSetValue needs to be
adapted to handle values of that type. Also connectivity
source/commontools/FValue.cxx and undoubtedly many other places, such as
source/commontools/DateConversion.cxx, etc.

-- 
Configure bugmail: https://bugs.freedesktop.org/userprefs.cgi?tab=email
------- You are receiving this mail because: -------
You are the assignee for the bug.



More information about the Libreoffice-bugs mailing list