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
What is data definition language?
Why do we use procedures in pl sql?
How much does sqlite cost?
Can we call a function containing dml statements in a select query?
What is %rowtype in pl sql?
what is the bond code in materialized view?
Why use truncate instead of delete?
Do we need commit after truncate?
Explain what is sql*plus?
How do you update f as m and m as f from the below table testtable?
How can I change database name in sql?
what is a scheduled jobs or what is a scheduled tasks? : Sql dba
How many unique keys can a table have?
what is bcp? When does it used? : Sql dba
what is a record in a database ? : Sql dba