[daisy] date format function in query language

Lieven Doclo ldo at schaubroeck.be
Thu May 3 08:08:49 CDT 2007


Hi,

We're currently developing an application that stores historical data in 
Daisy. The dates are stored in DATE fields.
Our problem lies when we start to query for dates: all dates returned by 
the query are displayed dd-mm-yy. When there's a date like 12/05/1924, 
it's displayed as 12/05/24, which in turn is converted back to 
12/05/2024 in Java.
When using dates earlier than 1/1/1900, as there is no way to find out 
what the date was as the query returns for example 01/02/15 (is it 1815, 
1915 or 2015?).

Is is possible to add a function to the query language that allows the 
formatting of date fields (something like format($datefield, 'dd-mm-yyyy'))?

Kind regards,

Lieven DOCLO
Schaubroeck N.V.



More information about the daisy mailing list