| |
GeekInterview.com > Interview Questions > Oracle > D2K
| Print | |
Question: Oracle Forms - Read Data and compare with sysdate
Answer: 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 |
| May 05, 2008 23:18:11 |
#1 |
| prasant0661 |
Member Since: May 2008 Total Comments: 4 |
RE: Oracle Forms - Read Data and compare with sysdate
|
| 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) |
| |
Back To Question | |
