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...)