I was asked this question today & can't remember the answer!! Anyone any ideas?

[Findlay, Colin]

If I add a column with a data type of VMSDATE the date and timestamp are
stored in Rdb.  If I then go into 
Quiz all I get back is the date.  Why? 


Example: 
Information for table JUNK7

Columns for table JUNK7:
Column Name                     Data Type        Domain
-----------                     ---------        ------
F1                              CHAR(1)
F2                              BIGINT
USERDTE                         DATE VMS
 Computed:      Automatic AS CURRENT_TIMESTAMP
Hot Standby> sql select userdte from junk7;
 USERDTE
 23-SEP-2003 10:35:22.49
1 row selected
                         R E C O R D   R E P O R T
         For DICTIONARY:  JD1:[GEN_METADATA.710G]GEN_BUSSYS_.PHD;
    Record:             JUNK7
    of File:            DATABASE
    Organization:       RELATIONAL
    Null Values Allowed:No
    Type:               RDB/VMS
    Open:               GEN_DATABASE

    Record Size:        17 Bytes

-- Record Contents --
    Item                                 Type            Size  Occ
Offset
r   F1                                   CHARACTER          1
0
r   F2                                   INTEGER SIGNED     8
1
r   USERDTE                              VMSDATE            8
9



> acc junk7 in database
> rep userdte
> go
23.09.2003
Extenza-Turpin                                                  PAGE   1

    Userdte

  23.09.2003



Regards,
Colin Findlay
FM Global, Windsor, UK
Tel.    +44 (0)1753 750000, ext 2113
Tel.    +44 (0)1753 750113  direct
Fax.   +44 (0)1753 750080
email  colin.findlay@fmglobal.com
mobile +44 (0)7740 366709