Answer / Ramesh Singh Brijwal

Both `now()` and `current_date()` return the current date and time in SQL, but they have subtle differences based on the database system you are using:

1. MySQL: Both functions return the current date and time in YYYY-MM-DD HH:MM:SS format. However, `now()` includes microseconds, while `current_date()` does not.
2. Oracle: `now()` returns the current date and time in DD-MON-RR HH24:MI:SS format, including fractions of a second. On the other hand, `current_date` returns only the date part (in the same format).

What is primary key secondary key alternate key candidate key?

1 Answers  

---

how to create a database in oracle?

3 Answers  

---

What are the qualities of 2nf?

1 Answers  

---

Why are sql stored procedures used?

1 Answers  

---

how many tupples can insert in 1 second in sql

1 Answers  

---

What are different types of queries in sql?

1 Answers  

---

What do you mean by stored procedures?

1 Answers  

---

write a query find which rows of a table is updated on 2 days before?

3 Answers   TCS,

---

Does it possible to pass object (or) table as an argument to a remote procedure?

1 Answers   TCS,

---

What are the types of subqueries?

1 Answers  

---

Write a query to get last 10 records from the table.

12 Answers   iNautix,

---

how are mysql timestamps seen to a user? : Sql dba

1 Answers  

---