Uniface on GitHub
Fixes and Updates
Author: firstname.lastname@example.org (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.
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.
thansk ..that solved the issue
© 2021 Uniface Privacy & Cookies | Privacy Statement | Legal