Re: SQL: Adding days to a date

At 10:39 05/02/2002, Rob Berendt wrote:
>I am trying to add days to a date in SQL.  Sample application
>Password last change date is logpwcd stored as a timestamp.
>Password expiration interval is logpwei stored as a decimal.
>
>Now I've got this big complex sql statement with the following in it:
>(CURRENT DATE > (logpwcd+logpwei))
>Evidently you can't add an integer to a timestamp.  Which makes sense
>because it didn't know if it was a day, seconds, or whatever.
>Trying
>(CURRENT DATE > (logpwcd+days(logpwei)))
>hurls with SQL0171-Argument 1 of function DAYS not valid.
>-- DAYS, the argument must be a date or a timestamp.

I think you want something like
   (CURRENT DATE > (DATE(LOGPWCD) + LOGPWEI DAYS))


Pete Hall
pbhall@ameritech.net
http://www.ameritech.net/users/pbhall/index.html