This content has been marked as final. Show 3 replies
this i tried it's not working but i used this one:
select emp_id from masterprocessdailydata where trunc(pdate)='15/OCT/2012';
and it's working.
but i have one more question this pdate value i am storing in one variable which is also date type.
but when i checked this through break point it's storing value with time also.
i want that it should store only date not time.
how to do that?