Answer Posted / m

to_char conversion function will convert given data to character data whereas to_data will convert given character data into date format model.


Also we can say like to_char conversion function use for convert invalid data into valid data.
and to_date conversion function will convert valid data into invalid.

Is there any restriction on the use of union in embedded sql?

875

---

what is union, minus and interact commands? : Sql dba

855

---

What is a left join?

689

---

What is dcl in sql?

685

---

What is percent sign in sql?

920

---

---

Which language is used in sql?

722

---

Which is faster truncate or drop?

769

---

how to decrement dates by 1 in mysql? : Sql dba

749

---

What is parameter substitution in sql?

748

---

What is the location of pre_defined_functions.

833

---

What are sql procedures?

753

---

define sql update statement ? : Sql dba

801

---

Is there a way to automate sql execution from the command-line, batch job or shell script?

743

---

How insert into statements in sql?

781

---

Can we write ddl statements in functions?

784

---