Dear all,
I have wrriten an sqlmod, show part of them as below:


SELECT DISTINCT PROCESS_FLOW_ID FROM FCA_LOT
WHERE CAST(TIME_STAMP AS DATE ANSI)>=
CAST(CURRENT_TIMESTAMP AS DATE ANSI)- INTERVAL'60' DAY)

According to bove codes, i want to get data 60 days ago. But i hope this
time interval is variable but not fix. So i try to edit bellow codes:

...CAST(CURRENT_TIMESTAMP AS DATE ANSI)- INTERVAL :vat_day DAY)
However, above codes are syntax wrong. How should i do or any sql statement
to reach my object ?

Hi Frank,

Try declaring the variable as data type INTERVAL eg:

declare :age interval year;
begin set :age =cast(50 as interval year); end;
select distinct last_name from employees WHERE CAST(BIRTHDAY AS DATE ANSI)

Regards Richard Maher

Frank Hung <frank.hung (AT) qdi (DOT) com.tw> wrote