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

[Michael Stucki]

Hi Ernesto,

do you still plan to work on this subject?

> 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.

Possibilities:

a) Use the update wizard and convert all fields

b) Keep old Unix timestamps but change the date fields into varchar and
   tag all new dates with a prefix, e.g. "D:22.08.2006/23:49:28+0200"

- michael
-- 
Use a newsreader! Check out
http://typo3.org/community/mailing-lists/use-a-news-reader/