Hi,

Carter Wojcik wrote:
Hi All -

I am currently working on a project that has a legacy
Oracle database.  It uses the column type Date instead
of Timestamp.  Are there any benefits of using
Timestamp over Date?

As an example, we have an auditing attribute named
dateAdded of type Date.  When creating a model from
the existing database, the following attribute
characteristics are populated:
  Name:  dateAdded
  Value Type:  D
  External Type: DATE
  ValueClass (Java):  NSTimestamp

Are these the correct (preferred) settings or should
they be set to something else?  If we were to use
Timestamp for dateAdded in the database, would Value
Type = T and External Type = Timestamp?  Can you use a
Value Type = T in the above example?

Thanks for the help.

Carter

I have been using the following with Oracle 8i.

       {
            allowsNull = Y;
            columnName = EST_COMPLETION_DATE;
            externalType = DATE;
            name = estCompletionDate;
            valueClassName = NSCalendarDate;
        }

regards,
  - shaun
_______________________________________________
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