First of all, I'm sorry for double posting this question in the mail- group and in the forum, not sure which is more appropriate, if not both :)
Hey there, As you probably know, the TIMESTAMP data type has limitations. (minimum and max dates allowed, cause of the the int base datatype - from Fri, 13 Dec 1901 20:45:54 UTC to Tue, 19 Jan 2038 03:14:07 UTC). What should we do when we need to accept dates that occur before or after that? I use Doctrine and MySql for my symfony projects. MySql supports the DATE data type which does not have the timestamp limitation. If I use in my schema a column of datatype "date" it translates it correctly into the SQL schema, but the validation process and internal conversions inside symfony+Docstrine handle it as a timestamp, and, therefore, make me limited again. I've reopened what seems to be a related ticket http://trac.symfony-project.org/ticket/5701 so that symfony can be changed. (I've looked into sf code but am quite lost of where to start to solve this, I would need to study the validation and doctrine classes) But, what is the best thing to do meanwhile to bypass this problem and accept old dates using a sfWidgetFormI18nDate? Thankyou very much for your help! Keep up the good work! --~--~---------~--~----~------------~-------~--~----~ You received this message because you are subscribed to the Google Groups "symfony users" group. To post to this group, send email to [email protected] To unsubscribe from this group, send email to [email protected] For more options, visit this group at http://groups.google.com/group/symfony-users?hl=en -~----------~----~----~----~------~----~------~--~---
