Skip to Content

Archived discussions are read-only. Learn more about SAP Q&A

Date Diff in webi

Hi - Is there a way in Webi to calculate date difference between two dates in hours or minutes?

Thanks!

Former Member
Former Member replied

Hi Ahamad,

You can create a Object in the Universe.

This is for SQL DB

DATEDIFF(hour, '06:46:45', '11:35:00')

DATEDIFF(minute, '06:46:45', '11:35:00')

For Oracle Database

datediff( 'ss', d1, d2 ) secounds

datediff( 'mi', d1, d2 ) minutes

datediff( 'hh', d1, d2 ) hours

Regards

Prashant

0 View this answer in context
Not what you were looking for? View more on this topic or Ask a question