OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » date function

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

date function [message #20895]

Fri, 28 June 2002 03:14

Raju
Messages: 74
Registered: March 1999

Member

Hi

Iam unable to get the output using this query.

select * from prichan where createdt=to_date('28-JUN-02','DD-MON-RR')

if I use the query without where clause all the rows are displaying. what could be the problem.

regards,
raju.

Report message to a moderator

Re: date function [message #20896 is a reply to message #20895]

Fri, 28 June 2002 03:27

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

you didnt truncate the HH:mi:ss fields
so, you cannot get a Match.
try this.
select * from prichan where createdt=trunc(to_date('28-JUN-02','DD-MON-RR'))

Report message to a moderator

Re: date function [message #20898 is a reply to message #20895]

Fri, 28 June 2002 04:13

Raju
Messages: 74
Registered: March 1999

Member

hi

Thanks, it is working with my table. But when I use with emp table it is not working why,
select * from emp where trunc(hiredate)=to_date('17-dec-80','DD-MON-RR')

Report message to a moderator