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 is the different between NOW() and CURRENT_DATE()?

Question Posted / shiwanshu

Answer Posted / shiwanshu

Now() Show the current date with time with AM/PM
Current_date () show only the current_date

Is This Answer Correct ?    0 Yes 0 No



Post New Answer       View All Answers


Please Help Members By Posting Answers For Below Questions

How do I automate a backup in mysql?

962

How to validate email addresses in mysql?

1093

What are the limitations of mysql?

1025

How to Recover a MySQL root password. Stop the MySQL server process. Start again with no grant tables. Login to MySQL as root. Set new password. Exit MySQL and restart MySQL server.

996

How to show certain selected rows with the value "pcds".

918

Why use stored procedures in mysql?

958

Write a query to fetch common records between two tables using mysql?

1000

How to list or view all databases from the mysql server.

904

Can we store images in mysql database?

890

Is mariadb better than mysql?

1023

Can you shard mysql?

908

What is mysql root?

930

How to calculate the difference between two time values?

972

What, if a table has one column defined as TIMESTAMP?

992

How do I kill a mysql query?

890