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?

Answer Posted / 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



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

What is data node in mysql cluster?

950


How do we delete a row in a table?

937


How do I backup mysql database on linux?

892


Is oracle better than mysql?

840


What is a mysql model?

897


What is difference between mysql and mysql workbench?

883


In which year mysql created?

926


How does mysql encrypt passwords?

858


What is a tinyint?

891


Where’s database data actually stored?

912


What are the different data types in mysql?

892


What is cast in mysql?

849


Explain the difference between primary key and candidate key in mysql?

919


How to load data files into tables with 'mysqlimport'?

940


why not null is not allowed at table level

2718