https://bugs.freedesktop.org/show_bug.cgi?id=51523
--- Comment #5 from Lionel Elie Mamane <[email protected]> 2012-06-28 09:53:29 PDT --- (In reply to comment #4) > basically in > the SQL standard TIME is indeed a clock time (the time part of a full > datetime/timestamp). For a duration, type INTERVAL seems more appropriate. > Except that HSQLDB 1.8 (used as our embedded HSQL) does not support that > datatype. Use a database backend that supports it, I suppose <shrug> Except that Base itself does not support the INTERVAL datatype. <sigh> For this whole shebang to have a chance of working as expected, this would have to be added: 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. In the meantime using integers or floats to store "number of $SOME_TIME_UNIT" is probably the best one can do. SOME_TIME_UNIT=seconds and integers is probably the sanest (if seconds resolution is enough). -- 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
