How to convert ISO8601 to Date format in php

by

try this

$date="2014-03-13T09:05:50.240Z";

$fixed = date('Y-m-d', strtotime($date));

The complete date function documentation can be found here: http://php.net/manual/en/function.date.php

The PHP function “strtotime” does nothing else then converting your timestring into an unix timestamp.

Hope I could help 🙂

P.s.:
Just in case strtotime will return 0 try using this: 

$date="2014-03-13T09:05:50.240Z";

$fixed = date('Y-m-d', strtotime(substr($date,0,10)));

More Related Contents:

  1. Php date() Date and time is stuck [closed]
  2. How to separate DATE and TIME from DATETIME in MySQL?
  3. Set timezone in PHP and MySQL
  4. Date in a URL dd/mm/yyyy
  5. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  6. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  7. adding 1 day to a DATETIME format value
  8. Query database then email posts from where user is subbed to
  9. Can I parameterize the table name in a prepared statement?
  10. Convert from MySQL datetime to another format with PHP
  11. Getting raw SQL query string from PDO prepared statements
  12. Correct way to use LIKE ‘%{$var}%’ with prepared statements?
  13. Error in MySQL when setting default value for DATE or DATETIME
  14. PHP DateTime::modify adding and subtracting months
  15. MySQL Prepared statements with a variable size variable list
  16. MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
  17. How to list all months between two dates
  18. SQLSTATE[HY093]: Invalid parameter number: number of bound variables does not match number of tokens on line 102 [closed]
  19. Comma separated values in MySQL “IN” clause
  20. SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax — PHP — PDO [duplicate]
  21. PHP – Import CSV file to mysql database Using LOAD DATA INFILE
  22. How do you do multiple SQL statements in one mysql_query?
  23. Using MySQL’s TIMESTAMP vs storing timestamps directly
  24. MySQL/SQL retrieve first 40 characters of a text field?
  25. how do I get month from date in mysql
  26. MySQL, how to insert null dates
  27. Converting to date in PHP from yyyymmdd format
  28. Subtracting a certain number of hours, days, months or years from date
  29. How do I convert an ISO8601 date to another format in PHP?
  30. Aggregated query without GROUP BY

Leave a Comment