Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Newbie Q: Calculating Difference Between 2 Dates

Newbie Q: Calculating Difference Between 2 Dates

From: Scott C. <sdcairns_at_mindspring.com>
Date: Fri, 31 Jul 1998 13:44:40 -0400
Message-ID: <6psvs4$688$1@camel15.mindspring.com> 





I'm looking for the PL/SQL to calculate the difference between 2 dates,
specifically in # of seconds although I need it in all forms eventually (#
days, # hours, etc.).



The equivalent function in Transact-SQL (Sybase/MS SQL) was datediff (date
part, date1 , date2).   All I can find in PL/SQL is MONTHS_BETWEEN which
isn't very useful.



Received on Fri Jul 31 1998 - 12:44:40 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US