Answer / ismail

SELECT CURDATE(),SELECT CURRENT_DATE(),SELECT CURTIME(),
SELECT CURRENT_TIME(),SELECT now().

Answer / rajan vardawaj

SELECT CURDATE(); SELECT CURRENT_DATE(); SELECT CURTIME();
SELECT CURRENT_TIME();

Answer / vikas d.k. gupta

To get the Current Date:-
1. SELECT CURDATE();
2. SELECT CURRENT_DATE();
To get the Current Time:-
1. SELECT CURTIME();
2. SELECT CURRENT_TIME();
To get both at the same time:-
1. SELECT NOW();
2. SELECT SYSDATE();

how we can find nth max salary from an employe table by using my sql?

8 Answers  

---

Explain the different types of constraints?

0 Answers  

---

How can we store binary data in mysql?

2 Answers   HP,

---

What are the differences between MySQL_fetch_array(), MySQL_fetch_object(), MySQL_fetch_row()?

2 Answers  

---

How will show all records containing the name "sonia" and the phone number '9876543210'

0 Answers  

---

How important is to list the column names when doing an insert?

0 Answers  

---

What is the difference between heap table and temporary table?

0 Answers  

---

What is mysqladmin flush hosts?

0 Answers  

---

How many services is running in sql server?

3 Answers   ACC, V2 Solutions,

---

what is the main difference between myisam and innodb

2 Answers   Wipro,

---

How to delete the repeated records from a table?

0 Answers  

---

What is MySQL Stored Procedure?

1 Answers  

---