Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Best way to store & calc elapsed time
Message
De
12/03/2001 11:30:37
 
 
À
Tous
Information générale
Forum:
Oracle
Catégorie:
Autre
Titre:
Best way to store & calc elapsed time
Divers
Thread ID:
00484076
Message ID:
00484076
Vues:
51
Can anyone suggest a good way to store and then calculate elapsed time in hrs or minutes.

I currently have two date fields date_started and date_completed, both are date types.
1. Is this a good way to store start/stop times?
3. How do you calculate elapsed time in either minutes or hrs?

My first attempt was to take the difference of the two, such as
select date_completed - date_started.
But this appears to provide the difference in days.
I've also tried some to_num(to_char combinations but have not had any success.

Any suggestions would be greatly appreciated.

Thanks,
-Isaac
Suivant
Répondre
Fil
Voir

Click here to load this message in the networking platform