Convert Data in timestamp

Question

I have a data in my input text example: 07/22/2013 17:32 and I would like convert in timestamp for inset in my database how can i do?

Myabe the function is mktime but I don't know how use it.

I'm waiting for help thank you very much

There is a [manual](http://www.php.net/) that answers this kind of questions — Walter Tross, Jul 10 '13 at 16:01

score 3 · Accepted Answer · edited May 23 '17 at 12:29

3

Use strtotime() like,

echo $timestamp=strtotime('07/22/2013 17:32');

Possible Duplicate of How to convert date to timestamp in PHP?

edited May 23 '17 at 12:29

Community

1
1

answered Jul 10 '13 at 15:58

Rohan Kumar

40,431
11
76
106

score 1 · Answer 2 · answered Jul 10 '13 at 15:58

1

You can use PHP's strtotime()

$timestamp = strtotime('07/22/2013 17:32');

answered Jul 10 '13 at 15:58

Amal Murali

75,622
18
128
150

score 0 · Answer 3 · answered Jul 10 '13 at 16:00

0

I would use strtotime to convert the text string into a Unix timestamp.
From there, you can use date to reformat the timestamp as needed.

answered Jul 10 '13 at 16:00

Mr. Llama

20,202
2
62
115

score 0 · Answer 4 · answered Jul 10 '13 at 16:06

Most other answers are suggesting doing it in PHP with strtotime, but that's a silly option. It'll involve at least TWO format conversion (string -> int -> string), and there's also the danger of multiple timezone conversions coming into play and mangling your date before it ever gets saved into the table.

You can do it in MySQL directly, as a single string->native conversion:

INSERT INTO foo (datetimefield)
    VALUES (STR_TO_DATE('07/22/2013 17:32', '%m/%d/%Y %H:%i'));

Ref: http://dev.mysql.com/doc/refman/5.5/en/date-and-time-functions.html#function_str-to-date

Convert Data in timestamp

4 Answers4