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 sql profiler in oracle?
What are sql objects?
How to read/write files from pl/sql?
What are sql functions? Describe the different types of sql functions?
What is the use of sqldataadapter?
What is the difference between count 1 and count (*) in a sql query?
what is the difference between undefined value and null value? : Sql dba
What does plv msg allows you to do?
What do you understand by pl/sql packages?
What is a recursive join sql?
How to use distinct and count in sql query? Explain
What is the difference between function, procedure and package in pl/sql?
What is sql catalog?
Explain what is a subquery ?
What is a loop in sql?