Ravi Malghan wrote:
Hi: I have a statement such as follows
SELECT EVENT_DATA.dstport WHERE
FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -
INTERVAL 1 DAY) ORDER BY EVENT_DATA.utime;
Instead of using a value of 1 for interval, I want to
pass parameters so it will ask for the value when the
sql st
--- Ravi Malghan <[EMAIL PROTECTED]> wrote:
> Hi: I have a statement such as follows
>
> SELECT EVENT_DATA.dstport WHERE
> FROM_UNIXTIME(utime,'%Y-%m-%d') = (CURDATE() -
> INTERVAL 1 DAY) ORDER BY EVENT_DATA.utime;
>
> Instead of using a value of 1 for interval, I want to
> pass parameters so