Re: [keycloak-user] Getting timestamp from EVENT_ENTITY
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(a)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(a)lists.jboss.org
https://lists.jboss.org/mailman/listinfo/keycloak-user