Oracle Database Discussions

Hi

Oracle 11.2.0.4.0

I have a slight problem, of which I would like to have a solution.

So how can I use SYSDATE variable for the following query (with the timezone region):

Ofcourse this works, if I write this date value explicitly:

select to_timestamp_tz('15.11.2017 08:26:00 Europe/Tallinn', 'dd.mm.yyyy hh24:mi:ss TZR') from dual;

My goal is to get something like this work (but this does not work like that):

select to_timestamp_tz(''||sysdate||' Europe/Tallinn', 'dd.mm.yyyy hh24:mi:ss TZR') from dual;

Any ideas..

Thanks in advance..

Regards

Raul