-
time diff in minutes
multiply with 1440 and take the round of the result.
-
This is correct:
SQL> select round((to_date('01/01/01 01:15:00','mm/dd/yy hh24:mi:ss')-to_date('01/01/01 01:00:00','mm/dd/yy hh24:mi:ss'))*1440) from dual;
ROUND((TO_DATE('01/01/0101:15:00','MM/DD/YYHH24:MI:SS')-TO_DATE('01/01/0101:00:00','MM/DD/YYHH24:MI:
----------------------------------------------------------------------------------------------------
15
Posting Permissions
- You may not post new threads
- You may not post replies
- You may not post attachments
- You may not edit your posts
-
Forum Rules
|
Click Here to Expand Forum to Full Width
|