Interested to Buy Any Domain ? << Click Here >> for more details...
what is the difference between to_char and to_date
functions?
- 10 Answers
- 66863 Views
- Infosys, I also Faced
- E-Mail Answers
Answer Posted / kushal
to_char is used to convert dates into a character
representation, for example, if you want your query to
format the date differently:
i.e.
SELECT TO_CHAR(SYSDATE, 'DD/MM/YYYY HH24:MI:SS') FROM
dual; --> 09/06/2004 12:57:54
SELECT TO_CHAR(SYSDATE, 'Day ddth Month') FROM
dual; --> Wednesday 09th June
The to_date function is used when you have character input,
but need it as a date object (for example when the database
column is a Date, you need to insert a date)
i.e.
SELECT TO_DATE('01/01/2004', 'DD/MM/YYYY') FROM dual
SELECT TO_DATE('01/01/2004 13:13:13', 'DD/MM/YYYY
HH24:MI:SS') FROM dual
@madhu:-sysdate bydefault gives the date in
dateformat,which is prerequisite of the to_char.
For other dates we have to convert first in date format and
then operate to_char accordingly to change the format as
needed for the date.
| Is This Answer Correct ? | 31 Yes | 4 No |
Post New Answer View All Answers
What's the procedure?
What is indexes?
Table A Table B 1 1 2 1 3 1. Union & union all --> A Union B , A Union all B 2. Minus , Intersect --> A minus B , B Minus A , A Intersect B 3. Joins A join B , A Left Join B A Right Join B , A full Join B 4. %Type - Uses & Benifit 5. Truncate & Delete 6. Pragma Autonomus Transaction 7. how to Perform DDL from function or procedure 8. Can we have DML inside Function 9. Rank & Dense Rank diffrence 10. Water Mark in Oracle 11. Index , Can we have index in all column of table if no then why ?
Can we insert in view in sql?
How does one load ebcdic data? : aql loader
How many sectors are in a partition?
What is a sql instance vs database?
What is the main reason behind using an index?
What are the disadvantages of not performing database normalization?
What is null in pl/sql?
What does the sign mean in sql?
what is a cursor? : Sql dba
Where is all the data on the internet stored?
How can a function retun more than one value in oracle with proper example?
How exception is different from error?
