Hello,
If you do end_date - start_date, it will give you the difference between
the two dates in days.
Regards,
Laly.
Extranet
William.[Email Address Removed] - 28/07/2003 15:13
Pour : oracledba
cc :
Objet : Function to calculate elapse time between 2 dates
Hi everybody
Does anybody has written a function to calculate the elapsed time of 2
dates?
William.
Thanks in Advance.
---------------------------------------------------------------------
William Missin
Database Administrator
Network Operations Centre
Business Phone : +49 (0)227 36 05 42 80
Business FAX : +49 (0)227 36 05 42 09
Mobile Phone : +49 (0)151 121 69 870
Mail to : William.[Email Address Removed] <mailto:William.[Email Address Removed] GmbH & Co. KG
Michael-Schumacher-Straße 1
50170 Kerpen
---------------------------------------------------------------------
CONFIDENTIAL
The information contained in this email and any attachment is confidential.
It is intended only for the named addressee(s). If you are not the named
addressee please notify the sender immediately and do not disclose, copy or
distribute the contents to any person other than the intended addressee(s).
If you received this message in error, please immediately notify me by
sending email to william.[Email Address Removed] documentation is here:
http://tahiti.oracle.com/pls/tahiti/tahiti.homepage
To unsubscribe: send a blank email to oracledba-[Email Address Removed] subscribe: send a blank email to oracledba-[Email Address Removed] the list archive: http://www.LAZYDBA.com/odbareadmail.pl
Tell yer mates about http://www.farAwayJobs.com
By using this list you agree to these terms:
http://www.lazydba.com/legal.html
This message and any attachments (the "message") is
intended solely for the addressees and is confidential.
If you receive this message in error, please delete it and
immediately notify the sender. Any use not in accord with
its purpose, any dissemination or disclosure, either whole
or partial, is prohibited except formal approval. The internet
can not guarantee the integrity of this message.
BNP PARIBAS (and its subsidiaries) shall (will) not
therefore be liable for the message if modified.
---------------------------------------------
Ce message et toutes les pieces jointes (ci-apres le
"message") sont etablis a l'intention exclusive de ses
destinataires et sont confidentiels. Si vous recevez ce
message par erreur, merci de le detruire et d'en avertir
immediatement l'expediteur. Toute utilisation de ce
message non conforme a sa destination, toute diffusion
ou toute publication, totale ou partielle, est interdite, sauf
autorisation expresse. L'internet ne permettant pas
d'assurer l'integrite de ce message, BNP PARIBAS (et ses
filiales) decline(nt) toute responsabilite au titre de ce
message, dans l'hypothese ou il aurait ete modifie.
Oracle LazyDBA home page