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 many ways we can retrieve the date in result set of mysql using php?

0 Answers  

---

How do I setup a mysql database?

0 Answers  

---

How do I install and use mysql?

0 Answers  

---

What is timestamp in mysql?

0 Answers  

---

What is the difference between MyISAM Static and MyISAM Dynamic?

0 Answers  

---

How do I insert multiple rows in a table?

0 Answers  

---

How do you login to MySql using Unix shell?

0 Answers  

---

What are the 5 r's of managing behaviors?

0 Answers  

---

What is back end and front end?

0 Answers  

---

Can you tell how many values can set the function of mysql to consider?

0 Answers  

---

Give the syntax of REVOKE commands?

1 Answers  

---

Hi! I’m doing one Project in vb.net 2008 using mysql .In that Project have the following Issues.. 1.if one Employee getting Salary 1.2 lacs / annum means .. After he getting 1st month Salary i want to show remaining 11 month salary.. How can i Create Trigger for this Problem & How can i use it..

1 Answers  

---