How can I make a SQL that return to me a column date minus another column date with the format like this '05:55 PM'.
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;
SQL for Time
No, you didn't understand, I want to select the difference between two dates in this format.
date-date is a valid operation and the result is just a number. This is the difference of time. There can not be any am/pm attached to it.
Click Here to Expand Forum to Full Width