Jump to content


Photo

Representing distant past/future datetimes...


  • Please log in to reply
1 reply to this topic

#1 bqallover

bqallover
  • Members
  • PipPipPip
  • Advanced Member
  • 111 posts
  • LocationLeeds, UK

Posted 27 October 2006 - 12:58 AM

Hello!

I'm currently working on a PHP/MySQL app that needs to be able to handle arbitrary dates, possibly WAY in the past or future - beyond the 1901-2038 of 32-bit unix time and the 1901-2155 of MySQL.

I know that I can store the dates as strings and solve my problem that way, but then I miss out on the existing datetime functions.

Does anyone know of a workaround to this, e.g. forcing PHP to use 64-bit timestamps?, etc.  Or am I stuck with storing as strings?

Thanks.

#2 bqallover

bqallover
  • Members
  • PipPipPip
  • Advanced Member
  • 111 posts
  • LocationLeeds, UK

Posted 30 October 2006 - 10:51 PM

*bump*.  Anyone?




0 user(s) are reading this topic

0 members, 0 guests, 0 anonymous users