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...

  1. Categories >> Software >> Databases >> MySQL
  2. Suggest New Category

What are the difference between now and current_date in mysql?

Question Posted / hrindows@gmail.com

Answer Posted / hrindows@gmail.com

NOW
NOW() give you the current date time in the format 'YYYY-MM_DD HH:MM: SS'
CURRENT
CURRENT_DATE() will only give you the current date in format "YYYY-MM_DD"

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

Why MySQL is used?

1027

Is mysql free download?

854

How to create a trigger in mysql?

933

how to add a new column to an existing table?

1019

What is the storage engine for mysql?

960

What you can use regular expression for in mysql? Support your answer with an example?

908

What are the security alerts while using mysql?

1034

How do I completely remove mysql from windows?

970

What are procedures in mysql? Explain

977

What is the difference between timestamp and datetime in mysql?

1049

What is foreign key in mysql?

1035

Can you rename a database in mysql?

1027

How do I view tables in mysql workbench?

916

How can you calculate the sum of any column of a table?

1046

how can you test for null values in a database? : Mysql dba

937