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 -- - Frank Schönheit, Software Engineer [EMAIL PROTECTED] - - Sun Microsystems http://www.sun.com/staroffice - - OpenOffice.org Base http://dba.openoffice.org - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - - --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
