SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

How to convert the timing into 24 hrs basis

Alyssa T.Jan 10 2011 — edited Jan 10 2011

Hi friends

I have a requirement to the timing from 12hr to 24 basis in my sql script

SELECT request_id,

TO_CHAR (requested_start_date, 'DD-MON-RR HH:MI:SS') AS "Started At",

CEIL ((SYSDATE - actual_start_date) * 1440) AS "Running for Minutes"

FROM xxx;

here in the above script i have used this for requested_start_date .....TO_CHAR (requested_start_date, 'DD-MON-RR HH24:MI:SS')

But

how can i change this to 24hrs basis-> CEIL ((SYSDATE - actual_start_date) * 1440) AS "Running for Minutes"

thanks in advance

Thiliban

Edited by: welcome07 on Jan 10, 2011 11:36 AM

This post has been answered by John Spencer on Jan 10 2011

Jump to Answer

Locked Post

New comments cannot be posted to this locked post.

Locked on Feb 7 2011

Added on Jan 10 2011

4 comments

795 views