ADSM-L

variables and select from events table

2002-07-19 09:02:24
Subject: variables and select from events table
From: Joseph Dawes <jdawes AT CHUBB DOT COM>
Date: Fri, 19 Jul 2002 09:00:57 -0400
I'm trying to feed a date variable in the following sql statement:


select node_name,status  from events where(scheduled_start> '2002-07-16
19:00:00') and node_name like 'LN%' and (scheduled_start< '2002-07-17
19:30:00') and status!='Completed'




anybody know how to do this??
<Prev in Thread] Current Thread [Next in Thread>