Apple

On Jan 22, 2010, at 3:28 PM, Simon wrote:

I love these kind of posts. They make me feel that all those hundreds of posts that i've done of a similar ilk aren't so bad after all :-). My colleagues laugh at me because my posts like this are nearly always - in fact **always** - in the early hours of the morning when i've been doing one of those black-belt sessions.

i find red bull is the answer.

Simon

2010/1/22 David Avendasora <email@hidden>

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

References:
	>Date not showing correct time (From: David Avendasora <email@hidden>)
	>Re: Date not showing correct time (From: Chuck Hill <email@hidden>)
	>Re: Date not showing correct time (From: David Avendasora <email@hidden>)
	>Re: Date not showing correct time (From: David Avendasora <email@hidden>)
	>Re: Date not showing correct time (From: Simon <email@hidden>)