How can we convert between Unix & MySQL timestamps?

  • UNIX_TIMESTAMP is the command which converts from MySQL timestamp to Unix timestamp FROM_UNIXTIME is the command which converts from Unix timestamp to MySQL timestamp.

Previous Papers

Model Tests

Current Affairs

Question Answers

Related Question & Answers

What is SQLyog?

What is meant by transaction and ACID properties?

What do you mean by % and _ in the LIKE statement?

What is save point in MySQL?

What is the difference between primary key and unique key?

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
How can we convert between Unix & MySQL timestamps?
Home Ask Questions Study Current Affairs Previous Papers Kerala PSCIBPSUPSCRBITNPSCMPSCSSCCBSEUnited StatesModel Tests News More Answers Coaching Centres Careers Downloads Colleges