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


Please Help Members By Posting Answers For Below Questions

What is the need of merge statement?

543


What is update query?

539


How does cross join work?

492


What is indexing oracle sql?

548


What is information schema in sql?

572






How do you run a query?

579


How do I run a script in sql developer?

485


What is database white box testing and black box testing?

628


What found sql?

516


What does bitemporal mean?

587


What are the packages in pl sql?

564


Does pl/sql support create command?

570


What is the difference between inner join and outer join?

518


What is cursor and why it is required?

546


Is there a 64 bit version of ssms?

506