Answer Posted / naveen

to_char function is used to convert the given data into
character....
eg:to_char(sysdate,'month') which returns month alone...

to_date is used to convert the given data into date data
formate data type....

eg: to_date('070903', 'MMDDYY') would return a date value
of July 9, 2003.

How do I send sql query results to excel?

569

---

what are the properties and different types of sub-queries? : Sql dba

496

---

How can you maintain the integrity of your database on instances where deleting an element in a table result in the deletion of the element(s) within another table?

659

---

Can we use pl sql in mysql?

509

---

What is sql used for?

636

---

---

Can we call procedure in select statement?

512

---

What program will open a mdb file?

490

---

What are sql procedures?

574

---

How to get help at the sql prompt?

633

---

What is date functions?

564

---

What do you mean by table in sql?

518

---

What is the primary key?

529

---

What is the difference between the conventional and direct path loader? : aql loader

642

---

What is data type in database?

537

---

What is a null value?

653

---