View previous topic :: View next topic
|
Author |
Message |
sree reddy
New User
Joined: 20 Jul 2007 Posts: 27 Location: bangalore
|
|
|
|
I need a query for the below synario
i need a count for end timstamp <= current time stamp - 90 days.
Can any one please help me out.
Thanks |
|
Back to top |
|
|
dbzTHEdinosauer
Global Moderator
Joined: 20 Oct 2006 Posts: 6966 Location: porcelain throne
|
|
|
|
along the lines of
Select count(*)
from <your-table>
where your_timestamp_column <= Current_Timestamp - 90 days
????? |
|
Back to top |
|
|
sree reddy
New User
Joined: 20 Jul 2007 Posts: 27 Location: bangalore
|
|
|
|
SELECT COUNT(*) FROM AVGI06.VISS_RAW_EDOM 0001003
WHERE (END_TS <= CURRENT TIMESTAMP) - 90 DAYS; 0002003
---------+---------+---------+---------+---------+---------+---------+---------
DSNT408I SQLCODE = -104, ERROR: ILLEGAL SYMBOL "-". SOME SYMBOLS THAT MIGHT
BE LEGAL ARE: AND OR HAVING GROUP INTERSECT ORDER FETCH EXCEPT UNION
FOR
DSNT418I SQLSTATE = 42601 SQLSTATE RETURN CODE
DSNT415I SQLERRP = DSNHPARS SQL PROCEDURE DETECTING ERROR
DSNT416I SQLERRD = 3 0 0 -1 112 502 SQL DIAGNOSTIC INFORMATION
DSNT416I SQLERRD = X'00000003' X'00000000' X'00000000' X'FFFFFFFF'
X'00000070' X'000001F6' SQL DIAGNOSTIC INFORMATION |
|
Back to top |
|
|
Craq Giegerich
Senior Member
Joined: 19 May 2007 Posts: 1512 Location: Virginia, USA
|
|
|
|
Code: |
"SELECT COUNT(*) FROM AVGI06.VISS_RAW_EDOM WHERE (END_TS <= CURRENT TIMESTAMP) - 90 DAYS;" |
Try
Code: |
"SELECT COUNT(*) FROM AVGI06.VISS_RAW_EDOM WHERE END_TS <= (CURRENT TIMESTAMP - 90 DAYS);" |
|
|
Back to top |
|
|
|