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

[Edis, Robert]

Have you tried using FORMAT in the report statement?  The default format in the PHD is probably DD.MM.YYYY and that's all you're going to see.

BTW, where are you located.  I see the date output format is like used in Germany.

Regards,
Blue

-----Original Message-----
From: powerh-l-admin@cube.swau.edu
[mailto:powerh-l-admin@cube.swau.edu]On Behalf Of Findlay, Colin
Sent: Wednesday, October 01, 2003 9:48 AM
To: powerh-l@lists.swau.edu
Subject: I was asked this question today & can't remember the answer!!
Anyone any ideas?


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



= = = = = = = = = = = = = = = = = = = = = = = = = = = =
Mailing list: powerh-l@lists.swau.edu
Subscribe: "subscribe" in message body to powerh-l-request@lists.swau.edu
Unsubscribe: "unsubscribe <password>" in message body to powerh-l-request@lists.swau.edu
http://lists.swau.edu/mailman/listinfo/powerh-l
This list is closed, thus to post to the list you must be a subscriber.