what is the difference between to_char and to_date
functions?
- 10 Answers
- 63109 Views
- Infosys, I also Faced
- E-Mail Answers
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
How do you update f as m and m as f from the below table testtable?
Why do we need view in sql?
How do you use join?
What is the difference between having clause and where clause?
What is the primary use of normalization?
What does count (*) mean in sql?
Where is pl sql used?
What is difference between primary and secondary key?
Differentiate between % rowtype and type record.
What is cascade in sql?
What is assignment operator in pl sql?
What are some predefined exceptions in pl/sql?
What is synonyms?
how to fetch alternate records from a table? : Sql dba
What is query optimization in sql?
