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 14:28:53 -0500
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