Help with JDBC Select-statement: Convert timeMills to Date

[Former Member]

Hi everybody,

I would like to retieve records from a JDBC.

The JDBC has a date "CSTARTTIME" in calender form (time mills); e.g. 1240524000000.

Does anybody know how the select statement has to look, that the reponse message gives the date (CSTARTTIME) as a date (YYYYMMDDHHmmSS).

E.g.

SELECT TO_DATE(CSTARTTIME, 'DD/MM/YYYYHH12:MI:SS:FF') FROM MYTABLE

Thanks

Regards Mario

Edited by: Mario Müller on May 6, 2009 2:48 AM

[Former Member]

SELECT TO_DATE('01-jan-0001','dd-mon-yyyy') +

ticks/(10000000 * 60 * 60 * 24) ticks_date

FROM MYTABLE