what is the difference between to_char and to_date
functions?

Answer Posted / susan

To_char is to convert number or date(string format) to character format.
To_date is from character format to date,only fetches d data when dere s valid number..

Is This Answer Correct ?    2 Yes 5 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What are the different types of functions in sql?

509


What is package in pl sql with an examples?

538


Explain the select statement in sql?

608


Difference between table function and pipelined function?

574


How many commands are there in sql?

539






Is oracel sql developer written in java?

638


Describe types of sql statements?

541


what is sql server agent? : Sql dba

598


Why does sql need a server?

557


How do I find duplicates in the same column?

525


What are the constraints available in sql?

571


What are the main features of cursor?

617


What is the starting oracle error number?

558


What are the properties of a transaction?

548


What are joins in sql?

528