SQL for Time

[gopi123_r]

select to_char(sysdate,'hh12:mi AM') "Date" from dual;

this is to return with minus option

select '-'||to_char(sysdate,'hh12:mi AM') "Date" from dual;