MySQL convert date string to Unix timestamp

by

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

More Related Contents:

  1. Should I use the datetime or timestamp data type in MySQL?
  2. Timestamp with a millisecond precision: How to save them in MySQL
  3. Group mysql query by 15 min intervals
  4. MySql difference between two timestamps in days?
  5. Use MySQL to determine whether today is a user’s birthday
  6. Error in MySQL when setting default value for DATE or DATETIME
  7. MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
  8. MySQL Query to select data from last week?
  9. How to get the difference between two timestamps in seconds
  10. Mysql: Setup the format of DATETIME to ‘DD-MM-YYYY HH:MM:SS’ when creating a table
  11. Why there can be only one TIMESTAMP column with CURRENT_TIMESTAMP in DEFAULT clause?
  12. How to select date from datetime column?
  13. How to convert number of week into date?
  14. Set NOW() as Default Value for datetime datatype?
  15. SQL Query to show nearest date?
  16. How to subtract hours from a datetime in MySQL?
  17. MySQL compare DATE string with string from DATETIME field
  18. How to get current date & time in MySQL?
  19. MySQL – select data from database between two dates
  20. how to cast the hexadecimal to varchar(datetime)?
  21. MySQL CURRENT_TIMESTAMP on create and on update
  22. Calculating time difference between 2 dates in minutes
  23. When is a timestamp (auto) updated?
  24. Using MySQL’s TIMESTAMP vs storing timestamps directly
  25. MySQL column type “TIMESTAMP” implicitly includes “NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP”
  26. Get total hours worked in a day mysql
  27. MySQL select all rows from last month until (now() – 1 month), for comparative purposes
  28. How do I alter a mysql table column defaults?
  29. MySQL: Insert datetime into other datetime field
  30. Working with INTERVAL and CURDATE in MySQL

Leave a Comment