Hello,
I have a function to convert timestamp since the unix epoch to date format:
create or replace function timestamp_to_date(unix_timestamp integer) return date
as
begin
return TO_DATE('1970-01-01', 'YYYY-MM-DD') + numtodsinterval(unix_timestamp, 'SECOND');
end timestamp_to_date;
This works fine, but it doesn't count with timezones.
So what I'd like to have is the function which convert the Unix timestamp to DATE with timezone ('Europe/Prague')
Thanks for your suggestions,
Sincerely,
Robert