Convert mysql DB timestamp to int time for PHP touch [duplicate]

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) ... — user6763587
– user6763587, Commented Sep 6, 2016 at 21:27

Karim Mtl · Accepted Answer · 2016-09-06 21:29:46Z

1

In an object oriented syle:

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

answered Sep 6, 2016 at 21:29

Karim Mtl

1,2533 gold badges14 silver badges42 bronze badges

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

Comments

Dekel · Accepted Answer · 2016-09-06 21:27:53Z

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 6, 2016 at 21:27

Dekel

62.9k12 gold badges109 silver badges130 bronze badges

Collectives™ on Stack Overflow

Convert mysql DB timestamp to int time for PHP touch [duplicate]

2 Answers 2

Comments

Comments

Linked

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Linked

Related