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 !