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.

What is a primary key sql?

1044

---

Can we call stored procedure in function?

959

---

Mention what does plvtab enables you to do when you showthe contents of pl/sql tables?

1170

---

how can I make a script that can be bi-language (supports english, german)? : Sql dba

1015

---

What kind of join is join?

972

---

list out some tools through which we can draw e-r diagrams for mysql. : Sql dba

969

---

Why use subqueries instead of joins?

1081

---

Can we use ddl statements in stored procedure?

1154

---

Why we use stored procedure instead of query?

999

---

How to prepare for oracle pl sql certification?

1066

---

Write a unique difference between a function and a stored procedure.

998

---

What is a recursive join sql?

1076

---

Why partition by is used in sql?

1042

---

what is difference between delete and truncate commands? : Sql dba

1133

---

How do I create a sql script?

1103

---