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
67213 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 the starting oracle error number?

1058

What is Materialized View? In What Scenario we Use Materialized View?

9522

What is trigger price?

995

How can I delete duplicate rows?

1019

What is data types in sql?

1011

How many developers work on postgresql?

985

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1015

what is 'mysqlshow'? : Sql dba

1028

What is dml with example?

1093

Can we use ddl statements in stored procedure?

1154

Is there a 64 bit version of ssms?

961

how do you know the version of your mysql server? : Sql dba

1004

What are sql ddl commands?

1096

What is a unique key?

1056

What is procedure function?

1065