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.

Why functions are used in sql?

1044

---

How can get second highest salary in sql?

1026

---

How many subqueries can be nested in a statement?

1040

---

What is sql partition function?

1291

---

What are the different types of joins in sql?

1913

---

What are analytical functions in sql?

1079

---

Explain scalar functions in sql?

1105

---

Can cursors be part of a trigger body?

1693

---

How are functions and procedures called in PL/SQL?

1308

---

How do you declare a user-defined exception?

1076

---

What is difference between hql and sql?

1166

---

What is trigger explain it?

1078

---

What are sql constraints?

1228

---

What is the need of a partition key?

1029

---

how to use in conditions? : Sql dba

1062

---