PHP get timestamp from separate date and time

Question

I have two inputs, one for the date in yyyy/mm/dd format and another for time in 12:15 AM. Now I need to save into the the databse a timestamp. I get both inputs lets say:

$my_date = '2013/12/22';
$my_time = '12:50 PM';

How do I get a timestamp to save into db?

Thank you

Charlie74 · Accepted Answer · 2013-12-08 13:29:31Z

1

Give this a try...

$my_date = '2013/12/22';
$my_time = '12:50 PM';

$full_date = $my_date . ' ' . $my_time;

$timestamp = strtotime($full_date);

answered Dec 8, 2013 at 13:29

Charlie74

2,91317 silver badges23 bronze badges

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

Comments

Darragh Enright · Accepted Answer · 2013-12-08 13:29:35Z

1

Use DateTime:createFromFormat()

<?php

$my_date = '2013/12/22';
$my_time = '12:50 PM';

$d = sprintf('%s %s', $my_date, $my_time);

$dt = DateTime::createFromFormat('Y/m/d h:i A',  $d);
$ts = $dt->getTimestamp();

var_dump($ts);

Yields:

int 1387716600

Hope this helps :)

Edit

PHP's date format reference

answered Dec 8, 2013 at 13:29

Darragh Enright

14.2k8 gold badges45 silver badges49 bronze badges

4 Comments

Mahdi Over a year ago

I've upvoted this answer 'cause I believe this is the best and most updated answer so far here, but it seems that somebody after me have downvoted that as well. Just out of curiosity wondering what was the reason for that? Is there anything wrong with this answer?

Darragh Enright Over a year ago

Thank you @Mahdi. I'd also appreciate a comment on the downvote. Someone downvoted the accepted answer as well. Clearly these answers are not incorrect nor inaccurate. It's pretty mean spirited in my view to downvote without giving some sort of reason/feedback.

Darragh Enright Over a year ago

Regarding the answer itself, I work with dates and times a lot and I personally prefer to use the DateTime family of classes (DateTimeZone, DateInterval, DatePeriod etc.) because it provides some good functionality and flexibility. That said, there's nothing wrong with strtotime functions either - it's simply a matter of utility and desired functionality. I specifically used createFromFormat in this case because of the unusual format (Y/m/d, is like ISO8601 except it uses slashes) and explicitly defining the input format would minimise possible errors.

Charlie74 Over a year ago

Yeah, I'm not sure what's going on with the down voting around here... both of the correct answers (this and mine) were down voted, which doesn't make any sense to me at all.

edwardmp · Accepted Answer · 2013-12-08 13:28:43Z

0

You could use strtotime() to convert it into an UNIX timestamp.

E.g.:

$my_date = strtotime('2013/12/22');
$my_time = strtotime('12:50 PM');

Full date + time timestamp

$timestamp = strtotime('2013/12/22 12:50 PM');

More info: http://php.net/manual/en/function.strtotime.php

edited Dec 8, 2013 at 13:28

answered Dec 8, 2013 at 13:20

edwardmp

6,6316 gold badges53 silver badges80 bronze badges

11 Comments

Alejandro Over a year ago

but how do I get the whole date in one timestamp?

Mahdi Over a year ago

@AlejandroCasas like this strtotime('2013/12/22 12:50 PM');

edwardmp Over a year ago

@mahdi why do you accept another answer that is the same as mine and posted minutes later and accept that?

Charlie74 Over a year ago

Your original answer was wrong. Your edited answer is closer but still does not show the OP how to put his two variables together in to one string and then convert. The accepted answer provides the exact code to address the OP's problem.

Mahdi Over a year ago

@edwardmp I guess you're a little bit confused. This is not my question, or maybe you meant AlejandroCasas instead of me?

|

Collectives™ on Stack Overflow

PHP get timestamp from separate date and time

3 Answers 3

Comments

4 Comments

11 Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

4 Comments

11 Comments

Your Answer

Sign up or log in

Post as a guest

Related