#17 JDBC update function doesn't handle a Calendar properly
The JDBCExecuteUpdateFunction doesn't handle the
java.util.Calendar type properly. This is a particular
problem as DATE fields are returned as instances of
java.util.GregorianCalendar. Other time fields will be
returned as instances of java.lang.String.
The ideal solution to this would involve adding proper
support for dates and times into the language, then
updating the interface with an SQL database to handle
these types appropriately.
A work around is to manually construct a date string from
the calendar object as follows:
"%p/%p/%p".format( calendar.dateYear,
calendar.dateMonth, calendar.dateDate )
but this is dependant on the database in question and
how it parses dates. The above code forces PostgreSQL
to parse the date in the yyyy-mm-dd format, as the
dateYear function returns a four digit year.
