Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Search results for query: *

  • Users: plt737
  • Content: Threads
  • Order by date
  1. plt737

    Date-time substraction

    I have a sql statement like the following:<br>SELECT AVG(86400*(Disp_DT-Entry_DT))/60 AVG_TIME<br><br>How can I make a Crystal formula like the one above?? Disp_DT is Dispatch Time and Entry_DT is Entry Time. My Oracle time field is like the following: 2000,01,31,15,01,27 - <br>yyyy,mm,dd,hh,mm,ss.

Part and Inventory Search

Back
Top