Categories
How to calculate days between dates?

Summary
How to calculate days between dates?
Content
For example, I've two dates, the Delivery date and Ordering Date, how could I calculate the days between them, so that I'll find out how long it takes the goods out of warehouse? Is there any function in DVD to support this? Such as datediff ... BTW, I found DAYOFYEAR maybe useful, but it returned a attribute (A) but not a value(#), and I can't use it for further drilling. Thanks for your kindly reply.
Answers
-
in v3 of the product Oracle have introduced TIMESTAMPDIFF, I've used as part of a workflow (create new column with the calculation, you can chose the level of difference, context :
nterval is the specified interval. Valid values are: SQL_TSI_SECOND,SQL_TSI_MINUTE, SQL_TSI_HOUR,SQL_TSI_DAY,SQL_TSI_WEEK,SQL_TSI_MONTH,SQL_TSI_QUARTER,SQL_TSI_YEAR.
0 -
Thanks, it worked.
And any "# Value" would be divided by time periods now.
0