Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between to_char and to_date
functions?
- 10 Answers
- 67537 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 are the security recommendations while using mysql? : Sql dba
Explain dml and ddl?
What is the basic structure of an sql?
How to rename a column in the output of sql query?
Which join condition can be specified using on clause?
What is clause?
What is posting?
What do you know by pl/sql cursors?
column A column b | output 10 7 | 10 5 8 | 8 7 -9 | 7 3 5 | 5 0 6 | 6 Write a sql query to print such output.
Is left join faster than join?
Can cursors be part of a trigger body?
explain advantages of innodb over myisam. : Sql dba
What is the difference between sql and t sql?
What is crud diagram?
Why do we use triggers?
