Answer Posted / praveen

Let sysdate=30/07/2012;

let see dis query
select add_months(sysdate,-3) from dual;
//ans=07/30/2012-mm/dd/yyyy
select trunc(add_months(sysdate,-3),'mm') from dual;
//ans=07/01/2012-mm/dd/yyyy
select to_char(trunc(add_months(sysdate,-3),'mm'),'mm/dd/yyyy from dual;
//ans=07/01/2012-mm/dd/yyyy

Does pdo prevent sql injection?

935

---

What are tables and fields?

1044

---

how can we know the number of days between two given dates using mysql? : Sql dba

1050

---

How can check sql version from command line?

1094

---

What is the use of sqlerrd 3?

947

---

Where is all the data on the internet stored?

1024

---

What is nested table in pl sql?

1080

---

State some properties of relational databases?

1064

---

What are the different types of joins in sql?

1813

---

When is a declare statement required?

1147

---

how can you see all indexes defined for a table? : Sql dba

1005

---

What are different functions in sql?

951

---

What are all the common sql functions?

1038

---

what is online transaction processing (oltp)? : Sql dba

1001

---

What is a join?

1076

---