i need help to select command

Reply

Join Date: Feb 2006
Posts: 3
Reputation: aep91 is an unknown quantity at this point 
Solved Threads: 0
aep91's Avatar
aep91 aep91 is offline Offline
Newbie Poster

i need help to select command

 
0
  #1
Feb 27th, 2006
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...
Reply With Quote Quick reply to this message  
Join Date: Jun 2005
Posts: 71
Reputation: Kate Albany is an unknown quantity at this point 
Solved Threads: 1
Kate Albany Kate Albany is offline Offline
Junior Poster in Training

Re: i need help to select command

 
0
  #2
Feb 28th, 2006
Hi,

Use 'sysdate' - without the quotes.

example:

select sysdate from dual
/

Kate
Reply With Quote Quick reply to this message  
Join Date: Feb 2006
Posts: 3
Reputation: aep91 is an unknown quantity at this point 
Solved Threads: 0
aep91's Avatar
aep91 aep91 is offline Offline
Newbie Poster

It's work well

 
0
  #3
Mar 1st, 2006
thank's very greatfull for Kate Albany
for U're solution..
it's work well


(--^^--)
(--^^--)
BetmeN
Reply With Quote Quick reply to this message  
Reply

This thread is more than three months old.
Perhaps start a new thread instead?
Message:



Similar Threads
Other Threads in the Oracle Forum
Thread Tools Search this Thread



About Us | Contact Us | Advertise | DaniWeb | Acceptable Use Policy | RSS Feed

©2003 - 2009 DaniWeb® LLC