Convert mysql DB timestamp to int time for PHP touch

Question

I have a mysql timestamp which looks like this: 2016-08-31 21:54:33 . I need to use this timestamp in PHP touch: bool touch ( string $filename [, int $time = time() [, int $atime ]] )

How can I best convert into the int value needed in touch?

or convert the time on select `SELECT UNIX_TIMESTAMP(your_time_field) ...` — , Sep 06 '16 at 21:27

score 1 · Answer 1 · answered Sep 06 '16 at 21:27

1

If you want to convert string to timestamp you can use one of:

$str = '2016-08-31 21:54:33';
// Option #1:
strtotime($str);

// Option #2:
strptime($str, '%Y-%m-%d %H:%M:%S');

answered Sep 06 '16 at 21:27

Dekel

60,707
10
101
129

score 1 · Accepted Answer · answered Sep 06 '16 at 21:29

1

In an object oriented syle:

$dateTime = new DateTime("2016-08-31 21:54:33");
echo $dateTime->getTimestamp();

answered Sep 06 '16 at 21:29

Karim Mtl

1,223
3
11
39

Convert mysql DB timestamp to int time for PHP touch

2 Answers2