[Wonder-disc] Difference between date and dateTime prototypes in ERPrototypes

[Ricardo J. P. <rp...@ma...>]

Hi,

These are not documented anywhere, are they?  I'm trying to find out when to use date and when to use dateTime.

In reviewing these prototypes definitions for different databases (i.e. FrontBase, OpenBase) I see that dateTime is normally defined with externalType = TIMESTAMP which gives higher granularity for storing micro seconds (.000001).

But then it gets confusing because for ORACLE dateTime is defined as DATE.  I believe DATE does not store microseconds. 
For MySQL it is defined as DATETIME.  I'm not familiar with MySQL but I'm guessing it does not store microseconds.

At first I thought date was supposed to be used for attributes that only had a year, day and month and no time.  And dateTime for those attributes having a date and a time down to seconds.  But given that some definitions use TIMESTAMP, now I'm confused.

Does anybody know what's the deal behind these?  It seems to me like there should be a date, a dateTime and a timestamp prototype.

But I just recently started using prototypes and I'm not familiar with each one of them.

:-)

P.S. The following Jiras are related to dateTime and ORACLE.

http://issues.objectstyle.org/jira/browse/WONDER-387
http://issues.objectstyle.org/jira/browse/WONDER-421

Thanks,
Ricardo