what is the difference between to_char and to_date
functions?
- 10 Answers
- 62983 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / rajesh
to_char function is used to convert the given data into
character....
eg:to_char(sysdate,'month') which returns month alone...
to_date is used to convert the given data into date data
formate data type....
eg: to_date('070903', 'MMDDYY') would return a date value
of July 9, 2003.
| Is This Answer Correct ? | 137 Yes | 33 No |
Post New Answer View All Answers
Define a temp table?
How does sql*loader handles newline characters in a record? : aql loader
what is user defined functions? : Sql dba
What are the different types of database management systems?
Can pl sql procedure have a return statement?
What are all the ddl commands?
what are all types of user defined functions? : Sql dba
discuss about myisam index statistics collection. : Sql dba
Write a sql query to find the names of employees that begin with ‘a’?
What are data types in pl sql?
what is single byte over head in oracle..?
Which is faster joins or subqueries?
What are its different types of dbms?
what is self-join? : Sql dba
How do I partition a table in sql?
