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 protected]) > Help/Unsubscribe/Update your Subscription: > http://lists.apple.com/mailman/options/webobjects-dev/webobjects%40avendasora.com > > This email sent to [email protected] > > _______________________________________________ Do not post admin requests to the list. They will be ignored. Webobjects-dev mailing list ([email protected]) Help/Unsubscribe/Update your Subscription: http://lists.apple.com/mailman/options/webobjects-dev/archive%40mail-archive.com This email sent to [email protected]
