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

FAQ
It is currently Tue May 23, 2017 10:05 am


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

Author Message
mandrei99
Post  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: 245

Offline
 

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





Top
Display posts from previous:  Sort by  
E-mail friendPrint view

Topics related to - "Mysql convert unix timestamp to human readable format"
 Topics   Author   Replies   Views   Last post 
There are no new unread posts for this topic. How to calculate mysql time difference between unix timestamp column and now() format

mandrei99

0

4037

Fri May 31, 2013 4:10 am

mandrei99 View the latest post

There are no new unread posts for this topic. Mysql> how to store select Zulu / UTC timestamp in database

debuser

0

480

Fri Dec 16, 2011 5:23 am

debuser View the latest post

There are no new unread posts for this topic. Getting Postgre SQL query output format equivalent to MySql \G

mandrei99

0

628

Wed Jun 13, 2012 7:31 am

mandrei99 View the latest post

There are no new unread posts for this topic. MySql doesn't start: libexec/mysqld: File './mysql-bin.index' not found (Errcode: 13)

debuser

0

1017

Mon Feb 22, 2010 1:43 pm

debuser View the latest post

There are no new unread posts for this topic. Mysql: add column to table

debuser

1

1577

Fri Oct 08, 2010 1:38 am

sonee4 View the latest post

There are no new unread posts for this topic. Rename MySql table

debuser

1

480

Fri Oct 08, 2010 1:36 am

sonee4 View the latest post

There are no new unread posts for this topic. MySql rename table

admin

2

772

Mon Nov 28, 2011 3:39 am

Darwin View the latest post

There are no new unread posts for this topic. How to use a mysql stored procedure

debuser

1

457

Tue Nov 22, 2011 1:23 am

Darwin View the latest post

There are no new unread posts for this topic. Mysql: Cleaning binary logs

debuser

1

804

Tue May 18, 2010 9:45 am

designeru View the latest post

There are no new unread posts for this topic. Mysql change column's default value

debuser

0

994

Thu Aug 12, 2010 3:43 am

debuser View the latest post

 

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:  
News News Site map Site map SitemapIndex SitemapIndex RSS Feed RSS Feed Channel list Channel list


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



phpBB SEO