Tech
Forums
Jobs
Books
Events
Videos
Conference
Annual Conference
Bcrypt
Ai Conference
Live
More
Interviews
Certification
Training
Career
Members
News
Blogs
Contribute
An Article
A Blog
A Video
An Ebook
An Interview Question
Register
Login
6
Answers
Date Function in Oracle - URGENT
Ask a question
Ask a question
Upload Source Code:
Select only zip and rar file.
Riddhi Valecha
9y
497
1
Reply
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 !
Post
Reset
Cancel
Answers (
6
)
Next Recommended Forum
Datatable uses
Prevent more useres from edit same record in same time probl