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 the plv (pl/vision) package offers?

1044

---

what are null values? : Sql dba

951

---

What is the use of stored procedures?

1040

---

How do you use join?

936

---

Why do we use procedures in pl sql?

1031

---

what is union? : Sql dba

1022

---

What is rownum and rowid?

1028

---

Is vs as in pl sql?

983

---

What is scope of pl sql developer in future?

1013

---

What will you get by the cursor attribute sql%found?

961

---

Can we alter stored procedure?

983

---

Can a foreign key have a different name?

940

---

How to fetch alternate records from a table?

1227

---

What is union, minus and interact commands?

1283

---

How to call a javascript function from pl sql?

1131

---