A select epoch(e.date) from Entity e doesn’t work when date is an actual date type on Oracle.
We need to change the extraction pattern based on the type of the expression to trunc((cast(from_tz(cast(d1_0.creationDate as timestamp),'UTC') as date) - date '1970-1-1')*86400)
A
select epoch(e.date) from Entity edoesn’t work whendateis an actualdatetype on Oracle.We need to change the extraction pattern based on the type of the expression to
trunc((cast(from_tz(cast(d1_0.creationDate as timestamp),'UTC') as date) - date '1970-1-1')*86400)