[keycloak-user] Getting timestamp from EVENT_ENTITY

[Dmitry Telegin]

Hello Edmund,

This is beyond the SQL spec, and therefore will be database-dependent. For example, with PostgreSQL you can do this:

SELECT to_timestamp(event_time/1000) FROM event_entity;

Cheers,
Dmitry Telegin
CTO, Acutus s.r.o.
Keycloak Consulting and Training

Pod lipami street 339/52, 130 00 Prague 3, Czech Republic
+42 (022) 888-30-71
E-mail: info at acutus.pro

On Tue, 2019-01-29 at 14:07 +0800, Edmund Loh wrote:
> The EVENT_TIME column in the EVENT_ENTITY table is stored as datatype
> NUMBER(38,0). How can I go about converting this to a timestamp through the
> use of SQL statements?
> _______________________________________________
> keycloak-user mailing list
> keycloak-user at lists.jboss.org
> https://lists.jboss.org/mailman/listinfo/keycloak-user