You are viewing a plain text version of this content. The canonical link for it is here.

Posted to derby-user@db.apache.org by Sylvain RICHET <de...@gmail.com> on 2006/04/03 17:47:23 UTC

Implementing an "ersatz" of TO_DATE function ?

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