mikrimouse mikrimouse - 1 year ago 72
SQL Question

how to get current year in this format

to_char('01.01.2016')


I need to set that day and month are always 01.01. but year have to change depends on system date year.

Answer Source

begin SELECT '01.01.' || to_char(trunc(sysdate, 'yyyy'), 'yyyy') into :P86_P_DATUM_OD FROM dual; end;

Recommended from our users: Dynamic Network Monitoring from WhatsUp Gold from IPSwitch. Free Download