db-derby-user mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From "Sylvain RICHET" <derb...@gmail.com>
Subject Implementing an "ersatz" of TO_DATE function ?
Date Mon, 03 Apr 2006 15:47:23 GMT
Hi everyone,

Got a DERBY database which stores date informations in a BIGINT format, but
infortunately not in DATE format.

I would like to request with a GROUP BY (date) sql command ... e.g: having
computed informations PER DAY.
I just realize that i couldn't use a (SQL) TO_DATE function, because DERBY
doesn't implement it !!?

Any idea about a workaround ?

(i do not want to process this on my J2EE server, i want to filter directly
at SQL level...)

View raw message