difference between dates in min/sec/hours

Author: lalitpct@gmail.com (lalitpct)

are there inbuilt funstions to calculate the difference between two dates in hours or minutes on seconds
for eg A) 01-sept-2012 11:20:09 B) 06-sept-2012 01:22:00

3 Comments

  1. I don't believe so, no. You can do simple maths (date1-date2), but the returned answer is not of much use if the elapsed time is more than 30 days. Frankly, we usually find it's easier to parse the query in SQL (datediff) or Crystal, than to do it in Uniface.


    Author: Iain Sharp (i.sharp@pcisystems.co.uk)
  2. Subtraction of two dates gives you the difference as a fractional number of days. Simple multiplication will give you the amount of hours, minutes and seconds.


    Author: Dennis van Duijn (dennis.van.duijn@sogeti.com)
  3. thansk ..that solved the issue


    Author: lalitpct (lalitpct@gmail.com)