Linux, FreeBSD, Juniper, Cisco / Network security articles and troubleshooting guides

FAQ

It is currently Wed Sep 19, 2018 9:39 pm

ROOT ‹ Website Development and Databases ‹ Mysql ‹ Mysql convert unix timestamp to human readable format

Mysql Application & Query Optimization, Questions, Indexes, Bugs.

Post a reply

1 post • Page 1 of 1

Mysql convert unix timestamp to human readable format

« Previous topic | Next topic »

Author

Message

mandrei99

Post subject: Mysql convert unix timestamp to human readable format | Posted: Wed Jan 14, 2015 11:36 am

Joined: Tue Aug 04, 2009 9:16 am
Posts: 250

Mysql convert unix timestamp to human readable format

Mysql and Unix timestamps are numerical values representing number of seconds elapsed since 1st of January 1970.

Mysql: How to get timestamp of current time:

Code:

mysql> select UNIX_TIMESTAMP();
+------------------+
| UNIX_TIMESTAMP() |
+------------------+
|       1421249658 |
+------------------+
1 row in set (0.00 sec)

Mysql: How to convert unix timestamp to human readable format:

Code:

mysql> select FROM_UNIXTIME(UNIX_TIMESTAMP());
+---------------------------------+
| FROM_UNIXTIME(UNIX_TIMESTAMP()) |
+---------------------------------+
| 2015-01-14 17:34:49             |
+---------------------------------+
1 row in set (0.00 sec)

Note that timestamp involving functions in Mysql contain unix as this format is unix time format. More info about mysql date and time functions on mysql website: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html

			Tweet
Follow @IvordeCom

You might also be interested in:
How to calculate mysql time difference between unix timestamp column and now() format. Mysql> how to store select Zulu / UTC timestamp in database. Getting Postgre SQL query output format equivalent to MySql \G. MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13). Mysql: add column to table. Rename MySql table. MySql rename table. How to use a mysql stored procedure. Mysql: Cleaning binary logs. Mysql change column's default value.

Top

Post a reply

1 post • Page 1 of 1

Topics		Author	Replies	Views	Last post
Topics related to - "Mysql convert unix timestamp to human readable format"
	How to calculate mysql time difference between unix timestamp column and now() format	mandrei99	0	6652	Fri May 31, 2013 4:10 am mandrei99
	Mysql> how to store select Zulu / UTC timestamp in database	debuser	0	977	Fri Dec 16, 2011 5:23 am debuser
	Getting Postgre SQL query output format equivalent to MySql \G	mandrei99	0	1125	Wed Jun 13, 2012 7:31 am mandrei99
	MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)	debuser	0	1805	Mon Feb 22, 2010 1:43 pm debuser
	Mysql: add column to table	debuser	1	2395	Fri Oct 08, 2010 1:38 am sonee4
	Rename MySql table	debuser	1	1038	Fri Oct 08, 2010 1:36 am sonee4
	MySql rename table	admin	2	1420	Mon Nov 28, 2011 3:39 am Darwin
	How to use a mysql stored procedure	debuser	1	987	Tue Nov 22, 2011 1:23 am Darwin
	Mysql: Cleaning binary logs	debuser	1	1421	Tue May 18, 2010 9:45 am designeru
	Mysql change column's default value	debuser	0	1503	Thu Aug 12, 2010 3:43 am debuser

Who is online

Users browsing this forum: No registered users and 0 guests

You can post new topics in this forum
You can reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum

Jump to:

Channel list

ROOT ‹ Website Development and Databases ‹ Mysql

Delete all board cookies | The team | All times are UTC - 5 hours [ DST ]