I was asked this question today & can't remember the answer!!
Anyone any ideas?
mshure@endoxy.com
mshure@endoxy.com
Wed, 1 Oct 2003 10:41:21 -0500
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_01C38832.767DE3D0
Content-Type: text/plain
Alternatively, you could do a DATEEXTRACT(fldname, TIME) to load the time
into a separate field and use it any way you like.
-----Original Message-----
From: Hamilton, Allison [mailto:Allison.Hamilton@cognos.com]
Sent: Wednesday, October 01, 2003 10:27 AM
To: 'Findlay, Colin'; powerh-l@lists.swau.edu
Subject: RE: I was asked this question today & can't remember the answer!!
Anyone any ideas?
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
<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
<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
<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.
CONFIDENTIALITY NOTICE: This e-mail and any files transmitted with it are
confidential and are intended solely for the use of the individual or entity
to which they are addressed. This communication may also contain material
protected and governed by the Health Insurance and Portability and
Accountability Act (HIPAA). If you are not the intended recipient of this
e-mail and the information it contains or if you are not the employee or
agent responsible for delivering this e-mail and the information it contains
to the intended recipient, be advised that you have received this e-mail in
error and that any use, dissemination, forwarding, printing or copying of
this e-mail is strictly prohibited. If you have received this e-mail in
error, please contact the sender of this message.
------_=_NextPart_001_01C38832.767DE3D0
Content-Type: text/html
Content-Transfer-Encoding: quoted-printable
<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD>
<META HTTP-EQUIV=3D"Content-Type" CONTENT=3D"text/html; =
charset=3DUS-ASCII">
<TITLE>Message</TITLE>
<META content=3D"MSHTML 6.00.2800.1226" name=3DGENERATOR></HEAD>
<BODY hb_focus_attach=3D"true">
<DIV><FONT face=3DArial color=3D#0000ff size=3D2><SPAN=20
class=3D395374015-01102003>Alternatively, you could do a =
DATEEXTRACT(fldname,=20
TIME) to load the time into a separate field and use it any way you=20
like.</SPAN></FONT></DIV>
<BLOCKQUOTE dir=3Dltr style=3D"MARGIN-RIGHT: 0px">
<DIV></DIV>
<DIV class=3DOutlookMessageHeader lang=3Den-us dir=3Dltr =
align=3Dleft><FONT=20
face=3DTahoma size=3D2>-----Original Message-----<BR><B>From:</B> =
Hamilton,=20
Allison [mailto:Allison.Hamilton@cognos.com] <BR><B>Sent:</B> =
Wednesday,=20
October 01, 2003 10:27 AM<BR><B>To:</B> 'Findlay, Colin';=20
powerh-l@lists.swau.edu<BR><B>Subject:</B> RE: I was asked this =
question today=20
& can't remember the answer!! Anyone any =
ideas?<BR><BR></FONT></DIV>
<P><FONT size=3D2>Because VMSDATE does not report the time by =
default, never=20
has. You can force it out using output scale and picture as=20
in:</FONT></P>
<P><FONT size=3D2> REPORT VMS_DATE_SYS PICTURE "^^^^/^^/^^=20
^^:^^:^^.^^^" OUTPUT SCALE 9</FONT> </P>
<P><FONT size=3D2>-----Original Message-----</FONT> <BR><FONT =
size=3D2>From:=20
Findlay, Colin [<A=20
=
href=3D"mailto:colin.findlay@fmglobal.com">mailto:colin.findlay@fmglobal=
.com</A>]</FONT>=20
<BR><FONT size=3D2>Sent: Wednesday, October 01, 2003 10:48 AM</FONT> =
<BR><FONT=20
size=3D2>To: powerh-l@lists.swau.edu</FONT> <BR><FONT =
size=3D2>Subject: I was=20
asked this question today & can't remember the answer!!</FONT> =
<BR><FONT=20
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=20
timestamp are</FONT> <BR><FONT size=3D2>stored in Rdb. If I =
then go into=20
</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=20
JUNK7</FONT> </P>
<P><FONT size=3D2>Columns for table JUNK7:</FONT> <BR><FONT =
size=3D2>Column=20
=
Name &n=
bsp; =20
Data Type Domain</FONT> =
<BR><FONT=20
=
size=3D2>----------- &nbs=
p; =20
--------- ------</FONT> =
<BR><FONT=20
=
size=3D2>F1 &=
nbsp; &=
nbsp; =20
CHAR(1)</FONT> <BR><FONT=20
=
size=3D2>F2 &=
nbsp; &=
nbsp; =20
BIGINT</FONT> <BR><FONT=20
=
size=3D2>USERDTE &n=
bsp; &n=
bsp; =20
DATE VMS</FONT> <BR><FONT =
size=3D2> Computed: =20
Automatic AS CURRENT_TIMESTAMP</FONT> <BR><FONT size=3D2>Hot =
Standby> sql=20
select userdte from junk7;</FONT> <BR><FONT =
size=3D2> USERDTE</FONT>=20
<BR><FONT size=3D2> 23-SEP-2003 10:35:22.49</FONT> <BR><FONT =
size=3D2>1 row=20
selected</FONT> <BR><FONT=20
=
size=3D2> &nb=
sp; &nb=
sp; =20
R E C O R D R E P O R T</FONT> <BR><FONT=20
size=3D2> For =
DICTIONARY: =20
JD1:[GEN_METADATA.710G]GEN_BUSSYS_.PHD;</FONT> <BR><FONT=20
size=3D2> =20
=
Record:  =
; =20
JUNK7</FONT> <BR><FONT size=3D2> of=20
=
File: =
DATABASE</FONT> <BR><FONT size=3D2> =20
Organization: RELATIONAL</FONT> =
<BR><FONT=20
size=3D2> Null Values Allowed:No</FONT> <BR><FONT=20
size=3D2> =20
=
Type: &=
nbsp; =20
RDB/VMS</FONT> <BR><FONT size=3D2> =20
=
Open: &=
nbsp; =20
GEN_DATABASE</FONT> </P>
<P><FONT size=3D2> Record=20
Size: 17 Bytes</FONT> </P>
<P><FONT size=3D2>-- Record Contents --</FONT> <BR><FONT=20
size=3D2> =20
=
Item &n=
bsp; &n=
bsp; =20
=
Type =20
Size Occ</FONT> <BR><FONT size=3D2>Offset</FONT> <BR><FONT=20
size=3D2>r =20
=
F1 &nbs=
p; &nbs=
p; =20
CHARACTER =
1</FONT>=20
<BR><FONT size=3D2>0</FONT> <BR><FONT size=3D2>r =20
=
F2 &nbs=
p; &nbs=
p; =20
INTEGER SIGNED 8</FONT> <BR><FONT =
size=3D2>1</FONT>=20
<BR><FONT size=3D2>r =20
=
USERDTE  =
;  =
; =20
=
VMSDATE  =
;=20
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=20
userdte</FONT> <BR><FONT size=3D2>> go</FONT> <BR><FONT=20
size=3D2>23.09.2003</FONT> <BR><FONT=20
=
size=3D2>Extenza-Turpin &=
nbsp; &=
nbsp; &=
nbsp; &=
nbsp; =20
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>=20
<BR><FONT size=3D2>FM Global, Windsor, UK</FONT> <BR><FONT=20
size=3D2>Tel. +44 (0)1753 750000, ext 2113</FONT> =
<BR><FONT=20
size=3D2>Tel. +44 (0)1753 750113 =
direct</FONT> <BR><FONT=20
size=3D2>Fax. +44 (0)1753 750080</FONT> <BR><FONT =
size=3D2>email =20
colin.findlay@fmglobal.com</FONT> <BR><FONT size=3D2>mobile +44 =
(0)7740=20
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>=20
<BR><FONT size=3D2>Mailing list: powerh-l@lists.swau.edu</FONT> =
<BR><FONT=20
size=3D2>Subscribe: "subscribe" in message body to=20
powerh-l-request@lists.swau.edu</FONT> <BR><FONT =
size=3D2>Unsubscribe:=20
"unsubscribe <password>" in message body to=20
powerh-l-request@lists.swau.edu</FONT> <BR><FONT size=3D2><A=20
href=3D"http://lists.swau.edu/mailman/listinfo/powerh-l"=20
target=3D_blank>http://lists.swau.edu/mailman/listinfo/powerh-l</A></F=
ONT>=20
<BR><FONT size=3D2>This list is closed, thus to post to the list you =
must be a=20
subscriber.</FONT> </P>
<P><FONT size=3D2>Join us at Cognos' biggest event of the year<I> =
Enterprise=20
2003, The Cognos Business Forum</I>. Taking place in over 25 =
cities=20
around the world, it's an opportunity for Business and IT leaders to =
learn=20
about strategies for driving performance. Visit<U> <A=20
href=3D"http://www.cognos.com/enterprise03"=20
target=3D_blank>http://www.cognos.com/enterprise03</A></U> for more =
details.=20
</FONT></P>
<P><FONT size=3D2>This message may contain privileged and/or =
confidential=20
information. If you have received this e-mail in error or are =
not the=20
intended recipient, you may not use, copy, disseminate or distribute =
it; do=20
not open any attachments, delete it immediately from your system and =
notify=20
the sender promptly by e-mail that you have done so. Thank=20
you.</FONT></P></BLOCKQUOTE>
<P></P></BODY></HTML>
<P><FONT SIZE=3D2 FACE=3D"Arial">CONFIDENTIALITY NOTICE: This e-mail =
and any files transmitted with it are confidential and are intended =
solely for the use of the individual or entity to which they are =
addressed. This communication may also contain material protected and =
governed by the Health Insurance and Portability and Accountability Act =
(HIPAA). If you are not the intended recipient of this e-mail and the =
information it contains or if you are not the employee or agent =
responsible for delivering this e-mail and the information it contains =
to the intended recipient, be advised that you have received this =
e-mail in error and that any use, dissemination, forwarding, printing =
or copying of this e-mail is strictly prohibited. If you have received =
this e-mail in error, please contact the sender of this =
message.</FONT></P>
------_=_NextPart_001_01C38832.767DE3D0--