How to convert MySQL time to UNIX timestamp using PHP

Question

There are a lot of questions that ask about  UNIX timestamp to MySQL time   I needed the reversed way  yea    Any idea

User · Answer

You can mysql s UNIX TIMESTAMP function directly from your query  here is an example   SELECT UNIX TIMESTAMP  2007-11-30 10 30 19      Similarly  you can pass in the date datetime field   SELECT UNIX TIMESTAMP yourField

User · Answer

Slightly abbreviated could be     echo date  Y-m-d H i s   strtotime  mysqltime

User · Answer

Use strtotime         timestamp   strtotime  mysqltime   echo date  Y-m-d H i s    timestamp     Also check this out  to do it in MySQL way    http   dev mysql com doc refman 5 5 en date-and-time-functions html function unix-timestamp

User · Answer

From one of my other posts  getting a unixtimestamp    unixTimestamp   time      Converting to mysql datetime format    mysqlTimestamp   date  Y-m-d H i s    unixTimestamp     Getting some mysql timestamp    mysqlTimestamp    2013-01-10 12 13 37     Converting it to a unixtimestamp    unixTimestamp   strtotime  2010-05-17 19 13 37         comparing it with one or a range of times  to see if the user entered a realistic time   if  unixTimestamp  gt  strtotime  1999-12-15    amp  amp   unixTimestamp  lt  strtotime  2025-12-15            Unix timestamps are safer too  You can do the following to check if a url passed variable is valid  before checking  for example  the previous range check   if ctype digit   GET  UpdateTimestamp

User · Answer

time PHP   strtotime   datetime SQL

User · Answer

Instead of strtotime you should use DateTime with PHP  You can also regard the timezone this way    dt   DateTime  createFromFormat  Y-m-d H i s    mysqltime  new DateTimeZone  Europe Berlin      unix timestamp    dt- gt getTimestamp       mysqltime is of type MySQL Datetime  e  g  2018-02-26 07 53 00

[php] How to convert MySQL time to UNIX timestamp using PHP?

Examples related to php

Examples related to mysql

Examples related to timestamp