Re: Date not showing correct time
Re: Date not showing correct time
- Subject: Re: Date not showing correct time
- From: Chuck Hill <email@hidden>
- Date: Fri, 22 Jan 2010 12:14:12 -0800
On Jan 22, 2010, at 12:03 PM, David Avendasora wrote:
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.
Technically, it is the time that gets stripped off. :-P
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
--
Chuck Hill Senior Consultant / VP Development
Practical WebObjects - for developers who want to increase their
overall knowledge of WebObjects or who are trying to solve specific
problems.
http://www.global-village.net/products/practical_webobjects
_______________________________________________
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