OraFAQ Forum: Forms » Time Calculation

Home » Developer & Programmer » Forms » Time Calculation (Database 10g, Forms6i)

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

Time Calculation [message #405508]

Thu, 28 May 2009 02:44

snsiddiqui
Messages: 172
Registered: December 2008

Senior Member

Dear all

I have two different fields with DATE datatype and I am taking input in this foramt HH:MI mean they are storing time now I want to calculate difference between these two fields and show in other field.

Report message to a moderator

Re: Time Calculation [message #405515 is a reply to message #405508]

Thu, 28 May 2009 03:01

Littlefoot
Messages: 21826
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Subtract them! The result will be number of days (so you might need to "convert" it to hours / minutes / whatever.

Note that DATE datatype contains both date and time, regardless the format you use in a form.

Report message to a moderator