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 the unique index?
How are functions and procedures called in PL/SQL?
How do you respond to dementia behavior?
Can function return multiple values in sql?
How does an execution block start and end in pl sql?
What do you mean by dbms? What are its different types?
what is sql profiler? : Sql dba
How to get list of all tables from a database?
What are the types of join in sql?
How does index help in query performance?
What is a constraint?
What is an index? What are the types of indexes? How many clustered indexes can be created on a table?
is mysql query is case sensitive? : Sql dba
How do I truncate a sql log file?
What is sql and also describe types of sql statements?