what is the difference between to_char and to_date
functions?
- 10 Answers
- 62971 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / madhu
The Simple examples is correct but we take the date in date
format not like sysdate or hiredate.
if u select to_char('some date') and to_date('somedate')
explain with this examples if any one know.
| Is This Answer Correct ? | 7 Yes | 6 No |
Post New Answer View All Answers
Name three sql operations that perform a sort.
Is a secondary key the same as a foreign key?
What is sorting in sql?
what are date and time data types in mysql? : Sql dba
what is the use of friend function? : Sql dba
How to use sql*plus built-in timers?
Is inner join faster than left join?
What is a mutating table and a constraining table?
What are the different set operators available in sql?
Can cursors be part of a trigger body?
How to create your own reports in sql developer?
What are the basic sql commands?
Why do we go for stored procedures?
What is the advantage of index in sql?
What is mutating trigger?
