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/archive%40mail-archive.com

This email sent to [email protected]

Reply via email to