Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between to_char and to_date
functions?
- 10 Answers
- 67165 Views
- Infosys, I also Faced
- E-Mail Answers
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 is union and union all keyword in sql and what are their differences?
Why do we use joins?
What are the benefits of pl sql?
Is postgresql a server?
Explain the savepoint statement.
What is sql resultset?
What are different types of tables in sql?
State some properties of relational databases?
Which table is left in left join?
What is online transaction processing (oltp)?
What are the different schemas objects that can be created using pl/sql?
List different type of expressions with the example.
Name the operator which is used in the query for pattern matching?
who introduced sql?
Do prepared statements prevent sql injection?
