what is the difference between to_char and to_date
functions?
Answer Posted / m
to_char conversion function will convert given data to character data whereas to_data will convert given character data into date format model.
Also we can say like to_char conversion function use for convert invalid data into valid data.
and to_date conversion function will convert valid data into invalid.
| Is This Answer Correct ? | 1 Yes | 0 No |
Post New Answer View All Answers
Explain about various levels of constraint.
Is coalesce faster than isnull?
What is spool?
What is sql character function?
how do you tune the slow running queries in oracle db , explain the methodology
what is the difference between nested subquery and correlated subquery?
What does an inner join do?
How to write a query to show the details of a student from students table whose
how to use 'mysql' to run sql statements? : Sql dba
Where is pl sql used?
Explain what is a column in a table?
how can you create an empty table from an existing table? : Sql dba
what is an alias command? : Sql dba
Cite the differences between execution of triggers and stored procedures?
What is record in pl sql?