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
Uniface 9: difference between dates in min/sec/hours
- Rocketeer
- Rocketeer
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
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)
- Rocketeer
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
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)
- Rocketeer
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
thansk ..that solved the issue
Author: lalitpct (lalitpct@gmail.com)
Sign up
Already have an account? Login
Welcome to the Rocket Forum!
Please log in or register:
Employee Login | Registration Member Login | RegistrationEnter your E-mail address. We'll send you an e-mail with instructions to reset your password.
77 4th Avenue
Waltham, MA 02451 USA
