convert unix timestamp php

Question

I have a database that stores the time for me. I insert it from PHP using

date( 'Y-m-d H:i:s');

I then use this function to convert it to a unix timestamp in PHP

function convert_datetime($str) 
{
list($date, $time) = explode(' ', $str);
list($year, $month, $day) = explode('-', $date);
list($hour, $minute, $second) = explode(':', $time);

$timestamp = mktime($hour, $minute, $second, $month, $day, $year);

return $timestamp;
}

What I now need to do is convert this timestamp to the date and time in this format: yyyymmddhhmmss (without any hyphens, dashes, colons, etc).

Has anyone any ideas?

php.net/date has a complete list of date()'s formatting parameters — Pekka
– Pekka, Commented Sep 14, 2010 at 9:16

Sarfraz · Accepted Answer · 2010-09-14 09:18:19Z

16

You can use the strtotime and date function:

echo date('Ymdhis', strtotime($date));

answered Sep 14, 2010 at 9:18

Sarfraz

384k81 gold badges561 silver badges613 bronze badges

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

Comments

halfdan · Accepted Answer · 2010-09-14 09:16:58Z

11

Use date.

$date = date("YmdHis", $timestamp);

answered Sep 14, 2010 at 9:16

halfdan

34.3k8 gold badges82 silver badges88 bronze badges

Comments

Grumpy · Accepted Answer · 2010-09-14 09:17:40Z

3

here you go

print date("YmdHis",unixtimestamp);

answered Sep 14, 2010 at 9:17

Grumpy

2,2731 gold badge26 silver badges40 bronze badges

Comments

Maerlyn · Accepted Answer · 2010-09-14 12:48:28Z

2

If you're using mysql, it has a DATE_FORMAT function. You can call it like

SELECT DATE_FORMAT(`datefield`, "%Y%m%d%H%i%s") AS `date_formatted` FROM table;

So you get an already formatted date from your database.

answered Sep 14, 2010 at 12:48

Maerlyn

34.2k18 gold badges99 silver badges89 bronze badges

1 Comment

aidan Over a year ago

I would also recommend this approach rather than using PHP. I haven't done any benchmarks but I suspect it's orders of magnitude faster. Also, use NOW() in SQL, instead of date('Y-m-d H:i:s'); in PHP for the insertion, if you can.

Toto · Accepted Answer · 2010-09-14 09:18:29Z

1

Use the right format :

date('YmdHis');

answered Sep 14, 2010 at 9:18

Toto

91.7k63 gold badges97 silver badges135 bronze badges

Collectives™ on Stack Overflow

convert unix timestamp php

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

5 Answers 5

Comments

Comments

Comments

1 Comment

Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related