Why do timestamps have a limit to 2038?

by

The limit is imposed by the 4 byte signed integers that most C libraries use for representing that count. Quick math (assumes 365 day years, not exactly correct):

2147483648 seconds ~ 68.1 years

This also implies a lower limit of ~1900. Some libraries have started to introduce 64 bit epoch counts, but they are few and far between for the moment.

More Related Contents:

  1. Accessing dates in PHP beyond 2038
  2. Display which day it is? sunday or monday “php coding”? [closed]
  3. Converting timestamp to time ago in PHP e.g 1 day ago, 2 days ago…
  4. Timezone conversion in php
  5. PHP How to find the time elapsed since a date time? [duplicate]
  6. PHP & mySQL: Year 2038 Bug: What is it? How to solve it?
  7. How to convert date to timestamp in PHP?
  8. PHP: producing relative date/time from timestamps
  9. Getting date format m-d-Y H:i:s.u from milliseconds
  10. MySQL datetime fields and daylight savings time — how do I reference the “extra” hour?
  11. best practice to generate random token for forgot password
  12. What is a Unix timestamp and why use it?
  13. How to generate random date between two dates using php?
  14. NOW() function in PHP
  15. How to convert a 13 digit Unix Timestamp to Date and time?
  16. Get timestamp of today and yesterday in php
  17. Using MySQL’s TIMESTAMP vs storing timestamps directly
  18. Formatting an SQL timestamp with PHP
  19. Storing time information: Timezone required?
  20. How to convert MySQL time to UNIX timestamp using PHP?
  21. Subtracting a certain number of hours, days, months or years from date
  22. parse youtube video id using preg_match [duplicate]
  23. How to Remove Array Element and Then Re-Index Array?
  24. When to use static vs instantiated classes
  25. Page redirect after certain time PHP
  26. Find total number of results in mySQL query with offset+limit
  27. Parametrized PDO query and `LIMIT` clause – not working [duplicate]
  28. PHP to store images in MySQL or not?
  29. Remove all non-numeric characters from a string; [^0-9] doesn’t match as expected
  30. Why I am getting error when getting booking from database? [duplicate]

Leave a Comment