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

What are the difference between now and current_date in mysql?

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

Is sql similar to mysql?

820


How can you export the table as an xml file in mysql?

842


What is not null in mysql?

926


What are enums used for in mysql?

953


What are the advantages of mysql?

936


What is the maximum size of mysql database?

894


In which format data is stored in mysql database?

956


Can you tell the difference between ereg_replace() and eregi_replace()?

984


Is mysql still popular?

872


What is the current root password of mysql?

861


Which is better sqlite or mysql?

961


How many threads can mysql handle?

918


Can you tell which of the following where clauses is faster?

843


What is the latest version of mysql?

932


How do I run mysql without installing?

908