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 is union, minus and interact commands? : Sql dba
what are the features and advantages of object-oriented programming? : Sql dba
What is clustered and nonclustered index in sql?
What are all the common sql functions?
What is out parameter used for eventhough return statement can also be used in pl/sql?
How to test for null values?
what are the 'mysql' command line options? : Sql dba
what is an execution plan? When would you use it? How would you view the execution plan? : Sql dba
What does where 1 1 mean in sql?
What are sql*plus environment variables?
What is a left join?
Can we insert data into view?
How can we avoid duplicating records in a query?
What is a table?
What is java sql driver?