What is the difference between NOW() and CURRENT_DATE()?

  • NOW() command is used to show current year, month, date with hours, minutes and seconds while CURRENT_DATE() shows the current year with month and date only.

Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

How to resolve the problem of data disk that is full?

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

How to display Nth highest salary from a table in a MySQL query?

How can you change the root password if the root password is lost?

What are federated tables?

Related Practice Tests

MySQL Interview Questions for Freshers
Categories
AndroidC programmingC++ programmingCloud ComputingComputerComputer System ArchitecureData BaseData StructureInternet & Social MediaJava programmingManual TestingMS OfficeMySQLNetworkingOperating SystemPHPProgrammingSoftware EngineeringSoftware Testing
What is the difference between NOW() and CURRENT_DATE()?
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges