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

Explain ddl statements in pl/sql?

578


What is sql performance tuning?

497


Does oracle use sql?

514


What does dml mean?

545


What is the difference between left and left outer join?

516






What is the difference among union, minus and intersect?

546


What is the difference between execution of triggers and stored procedures?

552


Why commit is not used in triggers?

582


How do you declare a user-defined exception?

530


Is sql injection illegal?

597


How long it takes to learn pl sql?

533


what is the difference between undefined value and null value? : Sql dba

562


How do I audit the sql sent to the server?

525


What is cursor explain with example?

553


What is sap sql?

536