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:

Recommended Answers

All 2 Replies

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


(--^^--)

Be a part of the DaniWeb community

We're a friendly, industry-focused community of developers, IT pros, digital marketers, and technology enthusiasts meeting, networking, learning, and sharing knowledge.