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