Toad World® Forums

Time Conversion

Hello.

I am tyrin to covert a time shown as 001200 (12 hours) as 720 mins. I have tried the following but get errors when executing:

(MTTD)>=TO_DATE(‘000000’,‘HH24:MI:SS’).

I have also tried .
MTTD = to_date(‘000000’,‘HH24:MI:SS’) =trunc(sysdate,‘MM’)2460; and neither is working.

What am I doing incorrectly?

Thanks in advance.