- Trending Categories
Data Structure
Networking
RDBMS
Operating System
Java
iOS
HTML
CSS
Android
Python
C Programming
C++
C#
MongoDB
MySQL
Javascript
PHP
- 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 convert from Unix timestamp to MySQL timestamp value?
MySQL converts Unix timestamp to timestamp data type value with the help of FROM_UNIXTIME() function.
Example
mysql> Select FROM_UNIXTIME(1508622563); +-----------------------------+ | FROM_UNIXTIME(1508622563) | +-----------------------------+ | 2017-10-22 03:19:23 | +-----------------------------+ 1 row in set (0.00 sec)
Updated on 20-Jun-2020 06:35:33
- Related Questions & Answers
- Convert MySQL timestamp to UNIX Timestamp?
- How to convert MySQL datetime to Unix timestamp?
- Convert MySQL Unix-Timestamp format to date format?
- MySQL - Convert YYYY-MM-DD to UNIX timestamp
- How to convert Python date to Unix timestamp?
- Convert MM/DD/YY to Unix timestamp in MySQL?
- Convert dd/mm/yyyy string to Unix timestamp in MySQL?
- How to convert a Unix timestamp to time in JavaScript?
- Convert UNIX timestamp into human readable format in MySQL?
- How to convert unix timestamp string to readable date in Python?
- How to convert timestamp to datetime in MySQL?
- How to get the Unix timestamp in C#
- MySQL query to convert timestamp to month?
- Display only date from timestamp value in MySQL
- How to select date from timestamp in MySQL?
Advertisements