I was asked this question today & can't remember the answer!!
Anyone any ideas?
Hamilton, Allison
Allison.Hamilton@Cognos.COM
Wed, 1 Oct 2003 11:27:18 -0400
This message is in MIME format. Since your mail reader does not understand
this format, some or all of this message may not be legible.
------_=_NextPart_001_01C38830.80040260
Content-Type: text/plain;
charset="iso-8859-1"
Because VMSDATE does not report the time by default, never has. You can
force it out using output scale and picture as in:
REPORT VMS_DATE_SYS PICTURE "^^^^/^^/^^ ^^:^^:^^.^^^" OUTPUT SCALE 9
-----Original Message-----
From: Findlay, Colin [mailto:colin.findlay@fmglobal.com]
Sent: Wednesday, October 01, 2003 10: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.
Join us at Cognos' biggest event of the year Enterprise 2003, The Cognos
Business Forum. Taking place in over 25 cities around the world, it's an
opportunity for Business and IT leaders to learn about strategies for
driving performance. Visit http://www.cognos.com/enterprise03 for more
details.
This message may contain privileged and/or confidential information. If you
have received this e-mail in error or are not the intended recipient, you
may not use, copy, disseminate or distribute it; do not open any
attachments, delete it immediately from your system and notify the sender
promptly by e-mail that you have done so. Thank you.
------_=_NextPart_001_01C38830.80040260
Content-Type: text/html;
charset="iso-8859-1"
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 3.2//EN">
<HTML>
<HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3Diso-8859-1">
<META NAME=3D"Generator" CONTENT=3D"MS Exchange Server version =
5.5.2654.89">
<TITLE>RE: I was asked this question today & can't remember the =
answer!! Anyone any ideas?</TITLE>
</HEAD>
<BODY>
<P><FONT SIZE=3D2>Because VMSDATE does not report the time by default, =
never has. You can force it out using output scale and picture as =
in:</FONT></P>
<P><FONT SIZE=3D2> REPORT VMS_DATE_SYS PICTURE "^^^^/^^/^^ =
^^:^^:^^.^^^" OUTPUT SCALE 9</FONT>
</P>
<P><FONT SIZE=3D2>-----Original Message-----</FONT>
<BR><FONT SIZE=3D2>From: Findlay, Colin [<A =
HREF=3D"mailto:colin.findlay@fmglobal.com">mailto:colin.findlay@fmglobal=
.com</A>]</FONT>
<BR><FONT SIZE=3D2>Sent: Wednesday, October 01, 2003 10:48 AM</FONT>
<BR><FONT SIZE=3D2>To: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subject: I was asked this question today & can't =
remember the answer!!</FONT>
<BR><FONT SIZE=3D2>Anyone any ideas?</FONT>
</P>
<BR>
<P><FONT SIZE=3D2>If I add a column with a data type of VMSDATE the =
date and timestamp are</FONT>
<BR><FONT SIZE=3D2>stored in Rdb. If I then go into </FONT>
<BR><FONT SIZE=3D2>Quiz all I get back is the date. Why? </FONT>
</P>
<BR>
<P><FONT SIZE=3D2>Example: </FONT>
<BR><FONT SIZE=3D2>Information for table JUNK7</FONT>
</P>
<P><FONT SIZE=3D2>Columns for table JUNK7:</FONT>
<BR><FONT SIZE=3D2>Column =
Name &n=
bsp; Data =
Type Domain</FONT>
<BR><FONT =
SIZE=3D2>----------- &nbs=
p; =
--------- ------</FONT>
<BR><FONT =
SIZE=3D2>F1 &=
nbsp; &=
nbsp; CHAR(1)</FONT>
<BR><FONT =
SIZE=3D2>F2 &=
nbsp; &=
nbsp; BIGINT</FONT>
<BR><FONT =
SIZE=3D2>USERDTE &n=
bsp; &n=
bsp; DATE VMS</FONT>
<BR><FONT SIZE=3D2> Computed: =
Automatic AS CURRENT_TIMESTAMP</FONT>
<BR><FONT SIZE=3D2>Hot Standby> sql select userdte from =
junk7;</FONT>
<BR><FONT SIZE=3D2> USERDTE</FONT>
<BR><FONT SIZE=3D2> 23-SEP-2003 10:35:22.49</FONT>
<BR><FONT SIZE=3D2>1 row selected</FONT>
<BR><FONT =
SIZE=3D2> &nb=
sp; &nb=
sp; R E C O R D R E P O R T</FONT>
<BR><FONT SIZE=3D2> For =
DICTIONARY: JD1:[GEN_METADATA.710G]GEN_BUSSYS_.PHD;</FONT>
<BR><FONT SIZE=3D2> =
Record:  =
; JUNK7</FONT>
<BR><FONT SIZE=3D2> of =
File: =
DATABASE</FONT>
<BR><FONT SIZE=3D2> =
Organization: RELATIONAL</FONT>
<BR><FONT SIZE=3D2> Null Values Allowed:No</FONT>
<BR><FONT SIZE=3D2> =
Type: &=
nbsp; RDB/VMS</FONT>
<BR><FONT SIZE=3D2> =
Open: &=
nbsp; GEN_DATABASE</FONT>
</P>
<P><FONT SIZE=3D2> Record =
Size: 17 Bytes</FONT>
</P>
<P><FONT SIZE=3D2>-- Record Contents --</FONT>
<BR><FONT SIZE=3D2> =
Item &n=
bsp; &n=
bsp; =
Type =
Size Occ</FONT>
<BR><FONT SIZE=3D2>Offset</FONT>
<BR><FONT SIZE=3D2>r =
F1 &nbs=
p; &nbs=
p; =
CHARACTER =
1</FONT>
<BR><FONT SIZE=3D2>0</FONT>
<BR><FONT SIZE=3D2>r =
F2 &nbs=
p; &nbs=
p; INTEGER =
SIGNED 8</FONT>
<BR><FONT SIZE=3D2>1</FONT>
<BR><FONT SIZE=3D2>r =
USERDTE  =
;  =
; =
VMSDATE  =
; 8</FONT>
<BR><FONT SIZE=3D2>9</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>> acc junk7 in database</FONT>
<BR><FONT SIZE=3D2>> rep userdte</FONT>
<BR><FONT SIZE=3D2>> go</FONT>
<BR><FONT SIZE=3D2>23.09.2003</FONT>
<BR><FONT =
SIZE=3D2>Extenza-Turpin &=
nbsp; &=
nbsp; &=
nbsp; &=
nbsp; PAGE 1</FONT>
</P>
<P><FONT SIZE=3D2> Userdte</FONT>
</P>
<P><FONT SIZE=3D2> 23.09.2003</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>Regards,</FONT>
<BR><FONT SIZE=3D2>Colin Findlay</FONT>
<BR><FONT SIZE=3D2>FM Global, Windsor, UK</FONT>
<BR><FONT SIZE=3D2>Tel. +44 (0)1753 750000, ext =
2113</FONT>
<BR><FONT SIZE=3D2>Tel. +44 (0)1753 750113 =
direct</FONT>
<BR><FONT SIZE=3D2>Fax. +44 (0)1753 750080</FONT>
<BR><FONT SIZE=3D2>email colin.findlay@fmglobal.com</FONT>
<BR><FONT SIZE=3D2>mobile +44 (0)7740 366709</FONT>
</P>
<BR>
<BR>
<P><FONT SIZE=3D2>=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =
=3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D =3D</FONT>
<BR><FONT SIZE=3D2>Mailing list: powerh-l@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Subscribe: "subscribe" in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2>Unsubscribe: "unsubscribe =
<password>" in message body to =
powerh-l-request@lists.swau.edu</FONT>
<BR><FONT SIZE=3D2><A =
HREF=3D"http://lists.swau.edu/mailman/listinfo/powerh-l" =
TARGET=3D"_blank">http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>
<BR><FONT SIZE=3D2>This list is closed, thus to post to the list you =
must be a subscriber.</FONT>
</P>
<P><FONT SIZE=3D2>Join us at Cognos' biggest event of the year<I> =
Enterprise 2003, The Cognos Business Forum</I>. Taking place in =
over 25 cities around the world, it's an opportunity for Business and =
IT leaders to learn about strategies for driving performance. Visit<U> =
<A HREF=3D"http://www.cognos.com/enterprise03" =
TARGET=3D"_blank">http://www.cognos.com/enterprise03</A></U> for more =
details. </FONT></P>
<P><FONT SIZE=3D2>This message may contain privileged and/or =
confidential information. If you have received this e-mail in =
error or are not the intended recipient, you may not use, copy, =
disseminate or distribute it; do not open any attachments, delete it =
immediately from your system and notify the sender promptly by e-mail =
that you have done so. Thank you.</FONT></P>
</BODY>
</HTML>
------_=_NextPart_001_01C38830.80040260--