[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