converting time using strtotime PHP

Question

apologies this is probably a simple question - I am using php and JS to create a counter and I have stored a time using an SQL time field in my DB- I run a query to return this time but I now wish to convert this time into an integer, I assume I need to use the following, but I am lost on the syntax: http://www.electrictoolbox.com/using-strtotime-with-php/

any help would be appreciated. many thanks in advance

This answer might get you started. See also: php.net/strtotime — Amal
– Amal, Commented Feb 8, 2014 at 15:24
see here :1) Question asking tips: stackoverflow.com/questions/ask 2) stackoverflow.com/questions/4577794/… 3) stackoverflow.com/questions/17327509/how-to-convert-mysql-time — Istiaque Ahmed
– Istiaque Ahmed, Commented Feb 8, 2014 at 15:32
You've told us your column has the TIME data type. Now please let us know what kind of integer you need from a TIME item? For example, if the time is 00:00 (midnight) what do you want? If the time is 12:30 (a half-hour after noon) what do you want? — O. Jones
– O. Jones, Commented Feb 8, 2014 at 15:54

O. Jones · Accepted Answer · 2014-02-08 15:44:29Z

1

It's hard to tell from your question what exactly you mean by "an SQL time field."

MySQL offers four kinds of time-like data types: TIMESTAMP, DATETIME, TIME, and DATE. To some extent it matters which one your table contains.

It's also hard to tell what you mean by "convert this time into an integer." Do you mean a UNIX-style timestamp (number of seconds since 1-Jan-1970 00:00:00 UTC)?

If that's the case you can get your database to do this conversion: use

SELECT UNIX_TIMESTAMP(value) ...

in your query. That will work for all the time-like datatypes except TIME. (Strange, eh? TIME means time of day with no date, so that's why it doesn't work.)

Otherwise, without more information it's hard to tell you how to use php to do this: we can't tell what your converting from and what you're converting to.

answered Feb 8, 2014 at 15:44

O. Jones

109k17 gold badges134 silver badges187 bronze badges

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

1 Comment

TotalNewbie Over a year ago

I am using the SQL TIME data type

Collectives™ on Stack Overflow

converting time using strtotime PHP

1 Answer 1

1 Comment

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Linked

Related