Re: Patched MySQL plugin
Re: Patched MySQL plugin
- Subject: Re: Patched MySQL plugin
- From: Chuck Hill <email@hidden>
- Date: Fri, 1 Oct 2010 09:58:35 -0700
The problem is that GregorianCalendar still has a time zone which is what most people seem to want to avoid with date only values. Otherwise, really, you need a geographically referenced point in time.
On Oct 1, 2010, at 9:00 AM, Ramsey Gurley wrote:
>
> On Oct 1, 2010, at 11:33 AM, Ray Kiddy wrote:
>
>>
>> On Sep 30, 2010, at 12:12 PM, Mike Schrag wrote:
>>
>>>>>>> Calendar dates should not be represented by NSTimestamp. The Date prototype is wrong for using it IMHO.
>>>>>>
>>>>>> i couldn't agree more. but where do we go from here ?
>>>>>>
>>>>>> 1) leave the mysql date prototype as it is now, broken and unusable
>>>>>
>>>>> If it is broken, then either no one is using it, or they are using it in a way that your change would break.
>>>>
>>>> We should have unit tests for testing things like that, on most popular databases (MySQL, PostgreSQL, FrontBase, H2 and Oracle DB Express).
>>
>>> i think i heard a volunteer!
>>>
>>> ms _______________________________________________
>>
>> There is a place to start. I created an example app called TickTockMan. It is in Wonder, so it could be added to. When I created it, the response was deafening. Or I assume it was, because I found myself to be deaf. Or there was silence. One of those.
>>
>> And lots of people have talked, over the years, about a NSWallClockTime/Date class, one that could capture the situation where I look at the clock and see a "2:00" and I want to discuss it with someone else who can look at another clock, regardless of what time zone they are in. Does anyone already have code for that they are planning to check in to Wonder? I have a class, but I am sure others will find it quirky.
>>
>> - ray
>
> I have every intention of creating a calendarDate prototype as soon as I figure out how to interact with it in the UI. It will probably be something like
>
> GregorianCalendar->ERXGregorianCalendar (Subclassed to supply factory methods)
> &
> SimpleDateFormat->ERXCalendarFormat (Subclass to translate date strings entered into an ERXGregorianCalendar)
> &
> calendarDate prototype with an external type like dateTime to store the data in a way the database can compare. I assume that means it will be normalized to a constant time zone like GMT.
>
> And I may make another based on XMLGregorianCalendar for those of us working with JAX-WS web services... But if someone wants to build and test all that for me, I'll welcome it (^_~)
>
> Ramsey
>
> _______________________________________________
> Do not post admin requests to the list. They will be ignored.
> Webobjects-dev mailing list (email@hidden)
> Help/Unsubscribe/Update your Subscription:
>
> This email sent to email@hidden
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their overall knowledge of WebObjects or who are trying to solve specific problems.
http://www.global-village.net/products/practical_webobjects
Attachment:
smime.p7s
Description: S/MIME cryptographic signature
_______________________________________________
Do not post admin requests to the list. They will be ignored.
Webobjects-dev mailing list (email@hidden)
Help/Unsubscribe/Update your Subscription:
This email sent to email@hidden