[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