SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Interested in getting your voice heard by members of the Developer Marketing team at Oracle? Check out this post for AppDev or this post for AI focus group information.

how to fetch records for particular date

879469Jun 22 2013 — edited Jun 24 2013

Hi,

I have one table containing file_process_date column.It stores date and time when file is processed

Now i want to fetch the records from table having particular file process date say 21 June 2013

file_process_date file_name

19/06/2013 03:55:30 ABC

20/06/2013 06:20:12 PQR

21/06/2013 09:50:30 ABC

21/06/2013 ABC12

21/06/2013 ABC44

21/06/2013 ABC6688

21/06/2013 ABC99

21/06/2013 8:10:22 ABC

21/06/2013 8:10:22 ABC5969696

query used to fetch records

select * from table_name where file_process_date=to_date('21/06/2013','dd/mm/yyyy');

It only gives me only below records

21/06/2013 ABC12

21/06/2013 ABC44

21/06/2013 ABC6688

21/06/2013 ABC99

But i want all records of 21 june 2013(including time also)

I want below ouput

21/06/2013 09:50:30 ABC

21/06/2013 ABC12

21/06/2013 ABC44

21/06/2013 ABC6688

21/06/2013 ABC99

21/06/2013 8:10:22 ABC

21/06/2013 8:10:22 ABC5969696

Is there any way to get this ouput?

please help.

Thanks.

Locked Post

New comments cannot be posted to this locked post.

Locked on Jul 22 2013

Added on Jun 22 2013

8 comments

1,772 views