[TYPO3-dev] It works! Storing non-UNIX dates

Martin Kutschker martin.kutschker-n0spam at no5pam-blackbox.net
Fri Jun 23 20:39:07 CEST 2006


Ernesto Baschny [cron IT] schrieb:
> Martin Kutschker schrieb am 23.06.2006 14:21:
> 
>>> AdoDB time functions are very straightforward [1]. They provide working
>>> replacements for PHP native "unixtime" based time functions:
>> I'd go for Julian dates. The PHP calendar extension can deal with it,
>> but a PHP implementation may be used as a fallback *
>>
>> Julian date are also numbers, but cover AFAIK a much wider range (much
>> before 1900 and I think well beyond 2038).
> 
> I think from 4712 B.C until 4713 A.D. The problem here is that it's not
> compatible with unix timestamps, so current date fields would have to be
> "converted" and functions that calculate on that dates would need to be
> rewritten.

That wasn't my goal. Then of course using unsigned ints are the only 
way. Fine with me as it at least saves the birthday problem now.

Masi




More information about the TYPO3-dev mailing list