i try to make a select table with condition now such as;
<?
...
$res = $conn->Execute("SELECT ID_SKENARIO,DATE_I FROM T_SCENARIO WHERE DATE_I = NOW");
While(!$res ->EOF)
{
echo $res->fields[0];
}
...
?>
what is the right synta for condition date is now ?
please help me...
:sad:
Hi,
Use 'sysdate' - without the quotes.
example:
select sysdate from dual
/
Kate
thank's very greatfull for Kate Albany
for U're solution..
it's work well
(--^^--)
We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.