Walter A. March ha scritto:
Part of my SQL statement (an HSQLDB in Base OOo 2.0.3) is this:
MIN( "startTime" )
but that gives a decimal number evan toug the field is Time[TIME] in
the table.
I couldn't find anything about a format function in the HSQLDB
documentation except a hint that I might be able to use something like
CREATE ALIAS TF FOR "java.text.SimpleDateFormat.Formatdate";
but I am not really sure where to put that line.
so, instead, I used
concat(concat(HOUR(MIN( "startTime" )),':'),minute(MIN( "startTime" )))
but... its ugly AND sometimes I get stuff like 13:0.
FYI original qry:
SELECT "startDate", MIN( "startTime" ), "subject", "location", "note"
FROM "Appointments" "Appointments" GROUP BY "startDate", "subject",
"location", "note"
hints or help?
thanks!
WalterAM
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
Hello Walter,
said that queries shouldn't alter the original data formats, you can
re-format each query's field as you need once your query is opened.
Right click on the column header -> Column Format -> Time -> Time
Format. That's all. Don't forget to save the changes.
Hope this help,
Franco
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
