View previous topic :: View next topic
|
Author |
Message |
henriquecosta
New User
Joined: 06 Jan 2010 Posts: 9 Location: Lisbon, Portugal
|
|
|
|
Hello,
I need to build a query to use in an UNLOAD that fetches all registers with timestamp older than X days old, where X is a CHAR variable in one of our tables.
Is this possible? I have been trying:
WHERE TS_field < CURRENT_DATE -
(SELECT X_Char_Field
from PARAM_TABLE
where pk = 'yaddayadda') DAYS
I have also tried with (...) CURRENT_DATE - DEC(SELECT (...), but I keep getting syntax errors.
Can anywone recommend a way to do this?
Thanks,
Henrique |
|
Back to top |
|
|
GuyC
Senior Member
Joined: 11 Aug 2009 Posts: 1281 Location: Belgium
|
|
|
|
Code: |
...WHERE TS_field < CURRENT_DATE -
(SELECT integer(X_Char_Field)
from PARAM_TABLE
where pk = 'yaddayadda') DAYS |
Manual wrote: |
The result is the same number that would result from CAST(string-expression
AS INTEGER). Leading and trailing blanks are eliminated and the resulting
string must conform to the rules for forming an integer constant. If the whole
part of the argument is not within the range of integers, an error is returned. |
|
|
Back to top |
|
|
henriquecosta
New User
Joined: 06 Jan 2010 Posts: 9 Location: Lisbon, Portugal
|
|
|
|
Hi,
Worked great, thanks!! |
|
Back to top |
|
|
|