Date Function in Oracle - URGENT

Question

Hi.....

I have a table like -

ID	Number	Date1	Date2
1	1234	1/27/2015 4:24:43 PM	1/27/2015 4:43:43 PM
2	1234	1/27/2015 4:24:43 PM	1/27/2015 4:43:43 PM
3	7894	1/27/2015 4:43:43 PM	1/27/2015 4:43:43 PM
4	9080	1/27/2015 4:43:43 PM	1/27/2015 4:43:43 PM

I have to make 2 functions -
1. Function - Return Date
IN_NUMBER varchar2
Query = select Date1 (in dd-mmm-yyyy) format where Number = IN_NUMBER
--------------
My Issue -
How do I get dates such that the time part is eliminated ?? I just want "27-JAN-2015" format for date columns.
-----
If I run the function using dual table, it says - 0 rows returned. But, the table has values.

Please help !