Data Structure
Networking
RDBMS
Operating System
Java
MS Excel
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
Physics
Chemistry
Biology
Mathematics
English
Economics
Psychology
Social Studies
Fashion Studies
Legal Studies
- Selected Reading
- UPSC IAS Exams Notes
- Developer's Best Practices
- Questions and Answers
- Effective Resume Writing
- HR Interview Questions
- Computer Glossary
- Who is Who
How to get timestamp using MySQL?
You can get timestamp with the help of current_timestamp, now() and current_timestamp().
Case 1 − Using current_timestamp()
The query is as follows −
mysql> SELECT CURRENT_TIMESTAMP();
The following is the output displaying timestamp −
+---------------------+ | CURRENT_TIMESTAMP() | +---------------------+ | 2018-11-29 16:09:31 | +---------------------+ 1 row in set (0.00 sec)
Case 2 − Using now()
The query is as follows −
mysql> select now();
The following is the output −
+---------------------+ | now() | +---------------------+ | 2018-11-29 16:09:38 | +---------------------+ 1 row in set (0.00 sec)
You can get integer UNIX timestamp with the help of below query −
mysql> select unix_timestamp();
The following is the output −
+------------------+ | unix_timestamp() | +------------------+ | 1543488374 | +------------------+ 1 row in set (0.04 sec
Updated on: 29-Jun-2020
141 Views
Advertisements