Golgappa.net | Golgappa.org | BagIndia.net | BodyIndia.Com | CabIndia.net | CarsBikes.net | CarsBikes.org | CashIndia.net | ConsumerIndia.net | CookingIndia.net | DataIndia.net | DealIndia.net | EmailIndia.net | FirstTablet.com | FirstTourist.com | ForsaleIndia.net | IndiaBody.Com | IndiaCab.net | IndiaCash.net | IndiaModel.net | KidForum.net | OfficeIndia.net | PaysIndia.com | RestaurantIndia.net | RestaurantsIndia.net | SaleForum.net | SellForum.net | SoldIndia.com | StarIndia.net | TomatoCab.com | TomatoCabs.com | TownIndia.com
Interested to Buy Any Domain ? << Click Here >> for more details...


How many ways we can we find the current date using MySQL?

Answers were Sorted based on User's Feedback



How many ways we can we find the current date using MySQL?..

Answer / anish mathew

SELECT CURDATE( )

Is This Answer Correct ?    19 Yes 4 No

How many ways we can we find the current date using MySQL?..

Answer / lekhrajdeshmukh

By using now() we can also get the current date
for eg:-select * from tbl_student where
date(sub_date)=date(now());

where sub_date is column name.

Is This Answer Correct ?    7 Yes 3 No

How many ways we can we find the current date using MySQL?..

Answer / rohit

SELECT CURRENT_DATE();

Is This Answer Correct ?    6 Yes 2 No

How many ways we can we find the current date using MySQL?..

Answer / mansukh khandhar

echo date(y/m/d);

Is This Answer Correct ?    0 Yes 1 No

How many ways we can we find the current date using MySQL?..

Answer / guest

date getset()

u use this query

Is This Answer Correct ?    5 Yes 9 No

Post New Answer

More MySQL Interview Questions

How many threads can mysql handle?

0 Answers  


What does tee command do in MySQL?

1 Answers  


What is timestamp in mysql?

0 Answers  


What are the features of mysql?

0 Answers  


How do stored procedures work?

0 Answers  


I've looked but can't find a MySQL equivalent for MS SQL's xp_cmdshell. I have 7z files that I want to unzip and load into MySQL. I'm trying to write a sp to do the unzip, but I can't find a way to do that. Can anyone provide an example of a similar process in Windows? TIA.

0 Answers  


Differentiate CHAR_LENGTH and LENGTH?

0 Answers  


Why do we use views instead of tables?

0 Answers  


Is mysql still relevant?

0 Answers  


What is a tinyint in mysql?

0 Answers  


What is mysql57?

0 Answers  


Can we store files in mysql?

0 Answers  


Categories