what is the difference between to_char and to_date
functions?
Answer Posted / naveen
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 ? | 10 Yes | 0 No |
Post New Answer View All Answers
What are transaction and its controls?
Give the order of sql select?
what is sql profiler? : Sql dba
What are different types of functions in sql?
What are the subsets of sql?
What are the qualities of 2nf?
How many types of index are there?
what are integrity rules?
What is the difference between nested table and varray?
Does sql use python?
Explain raise_application_error.
How do you write a subquery?
What do you understand by pl/sql records?
What is sql select statement?
What do you understand by pl/sql packages?