what is the difference between to_char and to_date
functions?
Answer Posted / madhu
The Simple examples is correct but we take the date in date
format not like sysdate or hiredate.
if u select to_char('some date') and to_date('somedate')
explain with this examples if any one know.
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
What are the benefits of pl sql?
How many clustered indexes can be created on a table?
What is a unique constraint?
Can we use view in stored procedure?
Why do we need databases?
What is sql prepared statement?
What is trigger in sql and its types?
Why do we use procedures?
What is input buffer in sql*plus?
How do I order columns in sql?
What is a scalar value in sql?
What is oracle sql developer?
What is java sql driver?
What is the maximum number of triggers, you can apply on a single table?
What is sql entity?