October 25th, 2004, 03:10 PM
|
|
Contributing User
|
|
Join Date: Jun 2003
Location: Waco, Texas
|
|
Try something like this:
select (YourTimeStampColumn+ 28 DAYS) for the second part.
Don't know what the first part represents:
timestampadd_day(0,T4."CALENDAR_DATE")
are you trying to add 0 days to clanedar_date column???
fv
--------------
Quote: | Originally Posted by linux_cat Afternoon, i hope everyone is having a good day as I am not!!!..
I am currently software testing and part of this tedious process is converting developers SQL so it runs in DB2, however i have hit a stumbling block with one of the more coplex options, could someone please tell me how i would re-write::
and timestampadd_day(0,T4."CALENDAR_DATE") > timestampadd_day(28,(now()));
to run in DB2?
Thank you. |
__________________
...because that is the way we have always done it. We've been doing it like that for 80 Years! (How do we change that mindset?)
|
Dev Shed Forums Sponsor:
Del.icio.us
Digg
Google
Spurl
Blink
Furl
Simpy
Y! MyWeb
Linear Mode
