|
View previous topic :: View next topic
|
| Author |
Message |
a1javeed
New User
Joined: 10 Dec 2005
Posts: 20
Location: KUWAIT
|
|
|
|
HI,
How can i substract 1 year from a column defined as DATE using some SQL statements?
thanks in advance |
|
| Back to top |
|
 |
rajandhla
Active User
.jpg)
Joined: 18 Oct 2005
Posts: 182
Location: Luton UK
|
|
|
|
SELECT
CURRENT DATE - 12 MONTHS
FROM SYSIBM.SYSDUMMY1
Regards,
jai |
|
| Back to top |
|
|
a1javeed
New User
Joined: 10 Dec 2005
Posts: 20
Location: KUWAIT
|
|
|
|
Hi Jai,
thanks for this, but i want to substract from a column OF TABLE which is defined as DATE !!!!
Regards |
|
| Back to top |
|
|
a1javeed
New User
Joined: 10 Dec 2005
Posts: 20
Location: KUWAIT
|
|
|
|
hi Jai
You are right!!!
Before i misunderstood u.But i did check it thru spufi ,It is perfect.
Sorry n Thank u again
Regards |
|
| Back to top |
|
|
|
|
