Oracle Forms - Read Data and compare with sysdate

I want to retrieve data from table where apply date field from table which like
date = sysdate,
so i not got a data , what i do
e.g.
select date from abc where date = sysdate;

this is right or wrong ,plz give ans

Questions by mcmbsolutions

Showing Answers 1 - 3 of 3 Answers

prasant0661

  • May 15th, 2008
 

select app_date from application where app_date=sysdate;The above query is right but may not fetch record.sysdate defult format is = 'dd/mm/yyyy hh:mi:ss'app_date might format may be = 'dd/mm/yyyy'so please writeselect app_date from applicationwhere trunc(app_date)=trunc(sysdate)

  Was this answer useful?  Yes

Give your answer:

If you think the above answer is not correct, Please select a reason and add your answer below.

 

Related Answered Questions

 

Related Open Questions