what is the difference between to_char and to_date
functions?
- 10 Answers
- 64874 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 ? | 138 Yes | 33 No |
Post New Answer View All Answers
what are aggregate and scalar functions? : Sql dba
How do I run a sql script?
What is row_number () in sql?
How to display the records between two range in Oracle SQL Plus?
How do you respond to dementia behavior?
what are the differences between binary and varbinary? : Sql dba
what is the use of friend function? : Sql dba
What is the purpose of the primary key?
List the various privileges that a user can grant to another user?
How many types of cursors are available in pl/sql?
What is the cause of mutating table error and how can we solve it?
what are the limitations of identity column? : Transact sql
What is not in sql?
What operators deal with null?
How do sql databases work?
