--001
SELECT WGBS_DATEVALUE, 
(select to_char(sysdate, 'DD.MM.YY')||' '||to_char(sysdate, 'hh24:mi')  from dual) PCDATE,
(select to_char(sysdate, 'DD.MM.YY') from dual) PCDATEPART,
(select to_char(sysdate, 'hh24:mi') from dual) PTIMEPART 
FROM fideliodate;