[TYPO3-dev] RFC: Change roadmap for 4.5 and 5.0

[Ries van Twisk]

Elmar Hinz wrote:

>Dimitri Tarassenko schrieb:
>  
>
>>Elmar, I've been around;))) I do know that they are and why they are
>>there, but following your logics why do you think SQL developers
>>bothered creating date types at all? Try for example writing a select
>>statement to pick Tuesdays out of integers containing unix timestamps,
>>and you'll end up converting them to date types anyway. ADOdb is there
>>precisely to smooth all the troubles with date formats.
>>
>>    
>>
>
>You want to store also the weekdays into the DB, although they could be
>evaluated from the date? Hmm, interesting idear for a quicker search. But
>that rather seems to have the character of an automated index to me, than
>being a valid part of a normalized date.
>  
>
That's not what he ment....
He means that out of a unix timestamp it's hard to pick all thuesdays.. 
You need to do that in PHP
while in vact that can be done from SQL. Therfe is still a open bug 
about a somular issue in bugtarcker due
to that we cannot sore timezones properly. So using a real date field is 
the right way to go for future, not int(11)
(What is int(11) anyways in mysql.... horrible... )

>
>Elmar
>
>
>
>
>_______________________________________________
>TYPO3-dev mailing list
>TYPO3-dev at lists.netfielders.de
>http://lists.netfielders.de/cgi-bin/mailman/listinfo/typo3-dev
>  
>


-- 
Ries van Twisk
Freelance Typo3 Developer
=== Private:
email: ries at vantwisk.nl
web:   http://www.rvantwisk.nl/
skype: callto://r.vantwisk
=== Work:
email: ries at livetravelguides.com
web:   http://www.livetravelguides.com