MySQL convert date string to Unix timestamp

Question

How do I convert the following format to unix timestamp   Apr 15 2012 12 00AM   The format I get from DB seems to have AM at the end   I ve tried using the following but it did not work   CONVERT DATETIME  Sales SalesDate  103  AS DTSALESDATE    CONVERT TIMESTAMP  Sales SalesDate  103  AS TSSALESDATE  where Sales SalesDate value is Apr 15 2012 12 00AM

User · Answer

You will certainly have to use both STR TO DATE to convert your date to a MySQL standard date format  and  UNIX TIMESTAMP to get the timestamp from it   Given the format of your date  something like   UNIX TIMESTAMP STR TO DATE Sales SalesDate    M  e  Y  h  i p      Will gives you a valid timestamp  Look the STR TO DATE documentation to have more information on the format string

User · Answer

From http   www epochconverter com   SELECT DATEDIFF s   1970-01-01 00 00 00   GETUTCDATE     My bad  SELECT unix timestamp time  Time format  YYYY-MM-DD HH MM SS or YYMMDD or YYYYMMDD  More on using timestamps with MySQL   http   www epochconverter com programming mysql-from-unixtime php

User · Answer

For current date just use UNIX TIMESTAMP   in your MySQL query

User · Answer

Here s an example of how to convert DATETIME to UNIX timestamp  SELECT UNIX TIMESTAMP STR TO DATE  Apr 15 2012 12 00AM     M  d  Y  h  i p    Here s an example of how to change date format  SELECT FROM UNIXTIME UNIX TIMESTAMP STR TO DATE  Apr 15 2012 12 00AM     M  d  Y  h  i p      m- d- Y  h  i  p   Documentation  UNIX TIMESTAMP  FROM UNIXTIME

[mysql] MySQL convert date string to Unix timestamp

Examples related to mysql

Examples related to datetime

Examples related to timestamp

Examples related to unix-timestamp