Using strtotime for dates before 1970

by

From the documentation for strtotime():

strtotime() has a range limit between Fri, 13 Dec 1901 20:45:54 GMT and Tue, 19 Jan 2038 03:14:07 GMT; although prior to PHP 5.1.0 this range was limited from 01-01-1970 to 19-01-2038 on some operating systems (Windows).

What version of PHP are you running? And on what platform? Perhaps it’s time for an upgrade.

If you’re working with dates outside the 13 Dec 1901 to 19 Jan 2038 range, then consider using PHP’s DateTime objects which can work with a much wider range of dates.

Procedural:

$date = date_create($row['value']);
if (!$date) {
    $e = date_get_last_errors();
    foreach ($e['errors'] as $error) {
        echo "$error\n";
    }
    exit(1);
}

echo date_format($date, "F j, Y");

OOP:

try {
    $date = new DateTime($row['value']);
} catch (Exception $e) {
    echo $e->getMessage();
    exit(1);
}

echo $date->format("F j, Y");

More Related Contents:

  1. how to select only one value sql
  2. Math Symbol From Mysql To HTML? [closed]
  3. Insert Blobs in MySql databases with php
  4. Get all child, grandchild etc nodes under parent using php with mysql query results
  5. Laravel Migration table already exists, but I want to add new not the older
  6. Saving images in database mysql
  7. How can I do a migration in laravel 5.5?
  8. Best way to store IP in database?
  9. Which is fastest in PHP- MySQL or MySQLi?
  10. How to backup MySQL database in PHP?
  11. PHP Laravel: No connection could be made because the target machine actively refused it
  12. Auto Increment skipping numbers?
  13. Create PHP array from MySQL column
  14. SQL Query with binary data (PHP and MySQL)
  15. PDO bindParam into one statement?
  16. UNION syntax in Cakephp
  17. How do I format numbers to have only two decimal places?
  18. Convert Time String to Decimal Hours PHP [closed]
  19. How do i search from serialize field in mysql database?
  20. How to get last inserted id from table MySQL [duplicate]
  21. Is mysql_real_escape_string enough to Anti SQL Injection?
  22. How to make mysqli connect function?
  23. Group mysql results by category and display them into groups under each category
  24. How can I list data in sections by an ID, with a while loop in PHP? [closed]
  25. What is the PDO equivalent of function mysql_real_escape_string?
  26. Save array in mysql database
  27. Using PHP to upload file and add the path to MySQL database
  28. Installing PDO driver on MySQL Linux server
  29. PHP & mySQL: When exactly to use htmlentities?
  30. find in set in laravel ? example

Leave a Comment