PL/SQL time segment calculation

Posted by Steve on Stack Overflow See other posts from Stack Overflow or by Steve
Published on 2010-05-05T19:37:54Z Indexed on 2010/05/05 20:18 UTC
Read the original article Hit count: 266

Filed under:

plsql

|

toad

|

Oracle

|

sql

|

stored-procedures

Hi,

I need to figure how much time passed between 2 times. For example:

(14:00:00 - 13:15:00) * 24 = .75

I need this to later on convert KW to KWh, but that's not the point.

I can not find out how to do this in PL/SQL.

My date/time fields look like this in the DB:

1/23/2010 21:00:00

I would appreciate any suggestions.

Steve

© Stack Overflow or respective owner

Related posts about plsql

Iterating over files in PLSQL

as seen on Stack Overflow - Search for 'Stack Overflow'
Using a PLSQL script, is it possible to iterate over binary files in a folder and insert them as a BLOB in Oracle 10g? Any examples would be appreciated. >>> More
plsql show query

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi all, I have a small problem using oracle pl sql. I have a sql file with some cursor, etc, and the treatement fail but with no details. I have an idea about the problem (a function with parameters) but I would like to see the parameter for each call, to be able to debug, to see exactly with wich… >>> More
Get 2 recoeds from PLSQL Cursor

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi Guys... my Question is short, I create a cursor to get some values from my table I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, cause I want to make a calculation over the current record and the next record. in traditional… >>> More
Get two records from PLSQL cursor

as seen on Stack Overflow - Search for 'Stack Overflow'
My question is short. I create a cursor to get some values from my table. I want to get the current record of cursor (the fetched record) and the next record from the cursor without fetching it, because I want to make a calculation over the current record and the next record. In traditional programming… >>> More
PLSQL: How to go about it

as seen on Stack Overflow - Search for 'Stack Overflow'
I searched for this topic on SO but I did not found any recommendations and so am asking it as I am new to PLSQL and want to understand it: What is best way to get started with PLSQL ? What are best online resources or books available out there for understand PLSQL which you would recommend ? Do… >>> More

Related posts about toad

Is it possible to export saved passwords from Toad

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm looking for a way to export saved usernames/passwords from Toad for Oracle (9.5.0.31). It doesn't have to be in a usable format for importing - even a plaintext format would be fine. I believe the passwords are stored encrypted in CONNECTIONPWDS.INI, but from what I've read, that file doesn't… >>> More
Retrieving Stored procedures, Views, Functions, Triggers using Toad for Oracle

as seen on Stack Overflow - Search for 'Stack Overflow'
How can I get the scripts of Stored procedures, Views, Functions, Triggers in toad for oracle? >>> More
How to open multiple viewer windows in Toad?

as seen on Stack Overflow - Search for 'Stack Overflow'
Im sure this is pretty simple but I just cant seem to find the option. My Toad MySql install only seems to allow me to have one "Viewer" window open and hence its impossible to view multiple tables - or have a window open for each table Im working with. Does anyone know how to change this? >>> More
DBMS debugger causes TOAD to hang

as seen on Stack Overflow - Search for 'Stack Overflow'
I can start the dbms debugger in Toad and use it normally but if I hit the 'halt execution' button or just hit the 'Run' button to reach the end of the function it causes TOAD to hang. Windows reports it as not responding and I have to kill it through the task manager. I have had this problem in… >>> More
Using Toad with 64bit Oracle Client and Windows 7 64bit Operating System

as seen on Stack Overflow - Search for 'Stack Overflow'
After downloading the latest version of Toad for Windows 7 64bit, I am struggling to get it to connect to the database using the existing full Oracle Client that is already on the desktop. The Oracle Client that is there is a 64bit version and is version 12c. When running Toad it says that there is… >>> More