Subtracting time in different formats in PHP

Question

Hi I'd like to take an hour off of a time stored in my DB and output it.

$row['expiration_abs_date'] = '2012-11-05 16:03:08'

Here's what I have:

date("M-j H:i \P\S\T",strtotime($row['expiration_abs_date']))

My best guess that doesn't work:

date("M-j H:i \P\S\T",strtotime($row['expiration_abs_date']) - strtotime(1 hour))

You could do it in the query. Here's a MySQL snippet: select date_add('2012-11-05 16:03:08', INTERVAL -1 HOUR) — uotonyh
– uotonyh, Commented Nov 16, 2011 at 19:07
SELECT timefield - INTERVAL 1 HOUR in mysql will do it for you without having to use multiple format conversions/roundtrips between time<->string values in PHP. — Marc B
– Marc B, Commented Nov 16, 2011 at 19:08

David Houde · Accepted Answer · 2011-11-16 19:13:01Z

1

date("M-j H:i \P\S\T",strtotime($row['expiration_abs_date'])-3600)

answered Nov 16, 2011 at 19:13

4,7881 gold badge22 silver badges29 bronze badges

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

Comments

Gunjan · Accepted Answer · 2011-11-16 19:09:44Z

1

strtotime($row['expiration_abs_date'].' -1 hour')

answered Nov 16, 2011 at 19:09

1,2373 gold badges12 silver badges23 bronze badges