dileepav
asked on
Help required in pulling records for a particular date and time?
Hi Experts,
Could you please help me in executing the following query:
Select * from RELAY_POLLER_LOG where lot_type_fk=1 and actual_date between '03-May-2011' and '04-May-2011'
I am using Oracle 10g as the database.
Thx
Dil.
Could you please help me in executing the following query:
Select * from RELAY_POLLER_LOG where lot_type_fk=1 and actual_date between '03-May-2011' and '04-May-2011'
I am using Oracle 10g as the database.
Thx
Dil.
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thx Experts
if there are equivalent answers posted at the same time you should split among all of them
try this...
Select * from RELAY_POLLER_LOG
where lot_type_fk=1
and actual_date between to_date('03-May-2011','dd-
if this doesn't work, please post the errors or other results