Use the the DAYS function in between dates.
select days('d1') - days('d2') from sysibm.sysdummy1
regards,
Manoj
*********** REPLY SEPARATOR ***********
On 8/29/02 at 11:22 AM Huber, Robert wrote:
>Greeting,
>I am quite new to db2 and need to form a join wherein I need to test for
>the
>number of days difference between two dates. Coming from a Sybase
>background
>the "and" clause would look something like " and datediff( day, date1,
>date2
>) > 45", where datediff is a Sybase built-in function.
>
>A search of the web has not given up any answer and I have no db2 manuals
>to
>review.
>
>Any pointers on how to deal with this greatly appreciated!
>
>Thanks...
>
>
>-
>::: When replying to the list, please use 'Reply-All' and make sure
>::: a copy goes to the list ([EMAIL PROTECTED]).
>*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
>*** For more information, check http://www.db2eug.uni.cc
-
::: When replying to the list, please use 'Reply-All' and make sure
::: a copy goes to the list ([EMAIL PROTECTED]).
*** To unsubscribe, send 'unsubscribe' to [EMAIL PROTECTED]
*** For more information, check http://www.db2eug.uni.cc
