Frank Schönheit - Sun Microsystems Germany wrote: > Hello Ariel, > >> Date calculation is one of the missing things in HSQLDB: there is the >> DATEDIFF function, but it lacks of other important function present in >> important RDBMS: DATE_ADD, DATE_FORMAT, etc. >> Besides, the string formating of dates is made by default to en-US [1]. >> >> I found a solution for my personal needs, let me tell you: >> ... >> after all this I wrote my own SQL functions in Java: >> ... >> I send you the JAR file and an ODB to test it. > > Hey, this is really cool! > > And brings me to: Did you already play with making this an extension? As > I understand it, you should be able to create an .oxt which contains the > JAR, and thus adds the functions to any OOo installation. > > You still have the changes to upload extension number 2 to > http://extensions.services.openoffice.org/taxonomy_menu/4/5 :) > > Ciao > Frank >
Mmmh, personally I have no problem to point the office to the jar. I think an extension is overkill, particularly if the functions provide nothing OOo-specific. However, it would be interesting to embed the library within a database, so queries simply work without installing anything. Impossible? Security issues? btw: Did anybody notice that you can not remove an archive in Tools>Options>Java>classpath... The "Remove" button remains disabled. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
