To_char is to convert number or date(string format) to character format. T

what is the difference between to_char and to_date
functions?

Question Posted / susan

10 Answers
67539 Views
Infosys, I also Faced
E-Mail Answers

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 is sql architecture?

1102

When you have to use a default "rollback to" savepoint of plvlog?

1252

Can I call a procedure inside a function?

1076

What are the different dcl commands in sql?

1234

How to use distinct and count in sql query? Explain

1086

what is collation? : Sql dba

1205

What is the difference between join and natural join?

984

How to prepare for oracle pl sql certification?

1109

How do I know if I have sql express or standard?

1067

What is the difference between union and union all command?

1151

Explain aggregate functions are available there in sql?

1051

What is the usage of nvl function?

1103

Explain dml and ddl?

1059

What is cursor in pl sql with examples?

1091

explain commit and rollback in mysql : sql dba

1076