How to calculate days between dates？

2939720836

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.

Alan Walsh

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.

2939720836

Thanks, it worked.

And any  "# Value" would be divided by time periods now.