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

Ernesto Baschny [cron IT] ernst at cron-it.de
Fri Jun 23 15:37:11 CEST 2006


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.

> Anyway I would suggest NOT to use the awkward API set of PHP "borrowed"
> from the Unix C-API.

Which "awkward API set" you mean? adodb-time functions?

Cheers,
Ernesto




More information about the TYPO3-dev mailing list