[TYPO3-english] Difference empty dates and 1/1/70 date

[Jigal van Hemert]

Hi,

On 16-9-2010 8:03, Dmitry Dulepov wrote:
> Jigal van Hemert wrote:
>> Unfortunately TYPO3 has currently no other date/time type with a wider
>> range. Even FLOW3 has only a date/time type which is stored (sorry, I
>> mean "persisted") in a Unix timestamp (integer database field).
>
> Oh, this is is disappointing :( I thought FLOW3 will finally use proper
> database fields...

Internally FLOW3 uses a PHP DateTime object (with a range of 10,000 BC - 
10,000 AD), but when "persisting" the data it converts it to a Unix 
timestamp to put it in an integer field.

I discussed this in the flow3.general list (posting to flow3.teams.core 
only resulted in error messages that posting was denied...) and it seems 
to be done this way because a field type had to be used which was 
supported by all DBMS.

(Yes, you may notice some mixed feelings about how "open" the 
development of FLOW3 seems to me)

-- 
Kind regards / met vriendelijke groet,

Jigal van Hemert
skype:jigal.van.hemert
msn: jigal at xs4all.nl
http://twitter.com/jigalvh