Re: Date not showing correct time
Re: Date not showing correct time
- Subject: Re: Date not showing correct time
- From: David Avendasora <email@hidden>
- Date: Fri, 22 Jan 2010 15:03:30 -0500
Yeah, so... um... see... if you tell EOF that you only want a Date (valueType = D) then it will strip the date off when it is read from the DB.
Whoda thunk?
But in my defense, isn't it odd that it doesn't strip it off when saving?
Anyway, the solution was very politely pointed out to be easily found here: http://en.wikibooks.org/wiki/WebObjects/EOF/Modeling/Common_Pitfalls_and_Troubleshooting
After 6 years of WO, you'd think I'd be past the "Common Pitfalls." I look forward to asking about Vertical Inheritance and deferred constraints tomorrow.
Dave
On Jan 22, 2010, at 2:28 PM, David Avendasora wrote:
>
> On Jan 22, 2010, at 2:16 PM, Chuck Hill wrote:
>
>>
>> On Jan 22, 2010, at 11:12 AM, David Avendasora wrote:
>>
>>> Hi all,
>>>
>>> I have a component that allows the user to modify a date field. The modification works just fine and the date field is changed in the database.
>>>
>>> The problem is that no matter what I do, the time is always displayed as the server's idea of midnight (GMT-5:00), no matter what the value is in the DB. If I don't use a formatter, I still get the same result. For example
>>>
>>> Database: 01/20/2010 01:00:00
>>> Form Field with Formatter: 01/20/2010 12:00
>>> Form Field without Formatter: 1/20/2010 05:00
>>>
>>> Here's the details:
>>> WO 5.4.3
>>> WOnder: 10544 (including EROraclePlugin)
>>> Oracle
>>>
>>> What would cause the time component to be stripped from the date before the formatter even gets to it?
>>
>>
>> Magic?
>>
>> What is the column type in the database? What is the value type in the model? Do you have it set to some sort of Date Only? The wrong prototype maybe?
>
> Doh. I knew I was forgetting "some" of the important details... :-)
>
> DB Info:
> DATA_TYPE: DATE
> DATA_LENGTH: 7
>
> Model Info:
> Prototype: EOJDBCOraclePrototypes date
> Datatype: Date
> External Type: Date
> Class: com.webobjects.foundation.NSTimestamp
> Server Timezone: (not selected)
>
> Actual .plist contents:
> {
> allowsNull = Y;
> columnName = ENDDATE;
> name = endDate;
> prototypeName = date;
> valueType = D;
> },
>
> _______________________________________________
> 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
>
>
_______________________________________________
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