Formatting an SQL timestamp with PHP

by

The date function expects an UNIX timestamp as its second parameter — which means you have to convert the date you get from the DB to an UNIX timestamp, which can be done using strtotime :

$db = '2010-02-20 13:14:09';
$timestamp = strtotime($db);
echo date("m-d-Y", $timestamp);

And you’ll get :

02-20-2010

You were passing the '2010-02-20 13:14:09' string to the date function ; that string is not a valid UNIX Timestamp.

'12-31-69‘ is probably 1970-01-01, in your locale ; and 1970-01-01 is the Epoch — the date that corresponds to the 0 UNIX Timestamp.

More Related Contents:

  1. Display which day it is? sunday or monday “php coding”? [closed]
  2. Php date() Date and time is stuck [closed]
  3. PHP How to find the time elapsed since a date time? [duplicate]
  4. How to convert date to timestamp in PHP?
  5. PHP mysql insert date format
  6. Getting date format m-d-Y H:i:s.u from milliseconds
  7. MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
  8. Accessing dates in PHP beyond 2038
  9. Calculate age based on date of birth
  10. How to generate random date between two dates using php?
  11. Set timezone in PHP and MySQL
  12. How to convert ISO8601 to Date format in php
  13. How to display a date as iso 8601 format with PHP
  14. Date in a URL dd/mm/yyyy
  15. Change date format (in DB or output) to dd/mm/yyyy – PHP MySQL
  16. mysql – INSERT date range into date columns IF dates don’t overlap with existing ones
  17. Using MySQL’s TIMESTAMP vs storing timestamps directly
  18. Storing time information: Timezone required?
  19. adding 1 day to a DATETIME format value
  20. How to convert MySQL time to UNIX timestamp using PHP?
  21. MySQL, how to insert null dates
  22. Subtracting a certain number of hours, days, months or years from date
  23. Select those record only from table 1 where city exist against state id in table 2 in PHP
  24. PHP PDO prepared statements
  25. Object of class DateTime could not be converted to string
  26. PHP MYSQL UPDATE if Exist or INSERT if not?
  27. mysql_real_escape_string VS addslashes
  28. Codeigniter Transactions
  29. php – add two hours to date variable
  30. php weeks between 2 dates

Leave a Comment