MySQL Timestamp format

Question

I have exported my database to a CSV file and the timestamp now liiks like this:

1384204028

How can I convert it to the typical format, for example 2013-01-19 03:14:07 ?

hakre · Accepted Answer · 2015-07-13 09:04:06Z

36

Use FROM_UNIXTIME()

SELECT FROM_UNIXTIME(1384204028);

or (equivalent but with parameter to control the format):

SELECT FROM_UNIXTIME(1384204028, '%Y-%m-%d %H:%i:%s');

edited Jul 13, 2015 at 9:04

hakre

200k55 gold badges454 silver badges868 bronze badges

answered Nov 16, 2013 at 15:39

John Conde

220k100 gold badges464 silver badges504 bronze badges

Sign up to request clarification or add additional context in comments.

Comments

Dmitry Seleznev · Accepted Answer · 2013-11-16 15:41:46Z

14

SELECT DATE_FORMAT(NOW(), '%Y-%m-%d %H:%i:%s')

answered Nov 16, 2013 at 15:41

Dmitry Seleznev

9657 silver badges7 bronze badges

Comments

and-bri · Accepted Answer · 2018-06-14 19:10:28Z

0

if you just want to add a line in your DB-table, where you have a field as TIMESTAMP, you don't need to call a function. You just can pas a string, sql will do the rest.

INSERT INTO `DB_TABLE`(`id`, `message`, `next_time`) VALUES (12, 'hallo world', '20180601151343')

and will even work like this:

INSERT INTO `DB_TABLE`(`id`, `message`, `next_time`) VALUES (12, 'hallo world', '2018-06-01 15:13:43')

answered Jun 14, 2018 at 19:10

and-bri

1,6742 gold badges24 silver badges37 bronze badges

Collectives™ on Stack Overflow

MySQL Timestamp format

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related