Oracle Database - How to get date and time with offset

Oracle syntax for date and time can be quite tricky and slightly different compared to Java.

Here is a SQL Query to get the date and time with & without offset:

select
    TO_CHAR(systimestamp, 'yyyy-MM-dd"T"HH24:MI:SS.ff3TZH:TZM') as "NOW_WITH_OFFSET",
    TO_CHAR(sysdate, 'yyyy-MM-dd"T"hh:MI:ss') as "NOW_WITHOUT_OFFSET"
from 
    dual;

More details about the format: Oracle Documentation

Tested with Oracle 12.