what is the difference between to_char and to_date
functions?
- 10 Answers
- 64858 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 two types of exceptions.
explain advantages of myisam over innodb? : Sql dba
What is sql table?
How to select 10 records from a table?
Write an sql query to select all records from the table?
Can you have more than one trigger on a table?
Explain the difference between sql and mysql.
Is it possible to include an insert statement on the same table to which the trigger is assigned?
What is sqlservr exe?
what is the difference between cluster and non cluster index? : Sql dba
Why triggers are used?
Explian rowid, rownum? What are the psoducolumns we have?
what is acid property in database? : Sql dba
Difference between global and parameter variables?
What is the difference between a primary key and a clustered index?
