what is the difference between to_char and to_date
functions?
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 is foreign key in sql with example?
Whis is not false in primary key?
What do you understand by case manipulation functions?
what are the differences between char and nchar? : Sql dba
What are the query optimization techniques?
differentiate between float and double. : Sql dba
What are the two types of cursors in pl sql?
What are the key differences between SQL and PL SQL?
What is column?
What is varchar example?
what is self-join? : Sql dba
Advantages and disadvantages of stored procedure?
What are sql built in functions?
How to prepare for oracle pl sql certification?
How many types of cursors supported in pl/sql?