I am tyring to covert a time shown as 001200 (12 hours) to 720 mins. I have tried the following but get errors when executing:
I have also tried .
MTTD = to_date('000000','HH24:MI:SS') =trunc(sysdate,'MM')*24*60; and neither is working.
What am I doing incorrectly?
Thanks in advance.