ca.portal.admin

Converting Date & Time

Discussion created by ca.portal.admin on Feb 15, 2008
Hello Listers,
Since I use a tame black hole as a filing system, maybe some of you can
give me a hand. I am trying to convert the date/time in the TCEDATIM
field to something displayable. Does anybody remember the formula for
doing this?

Thanks in advance.

Dan Hall
GE Capital Solutions
Database Administrator

T 513.217.5060
E dan.hall@ge.com
www.ge.com/capitalsolutions/

Lee Farm Rd.
Danbury, CT 06810
General Electric Capital Corporation
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
Re: Converting Date & Time
"Once again this list comes thru with flying colors. It took just minutes
for someone to remind me to use the IDMSIN01 macro to convert the time.
Plus a few other ideas of where to find the conversion code.

Thanks everyone.

Dan Hall
GE Capital Solutions
Database Administrator

T 513.217.5060
E dan.hall@ge.com
www.ge.com/capitalsolutions/

Lee Farm Rd.
Danbury, CT 06810
General Electric Capital Corporation



_____________________________________________
From: Hall, Dan (GE Comm Fin)
Sent: Friday, February 15, 2008 1:58 PM
To: 'IDMS-L'
Subject: Converting Date & Time

Hello Listers,
Since I use a tame black hole as a filing system, maybe some of you
can give me a hand. I am trying to convert the date/time in the
TCEDATIM field to something displayable. Does anybody remember the
formula for doing this?

Thanks in advance.

Dan Hall
GE Capital Solutions
Database Administrator

T 513.217.5060
E dan.hall@ge.com
www.ge.com/capitalsolutions/

Lee Farm Rd.
Danbury, CT 06810
General Electric Capital Corporation


"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
IDMS 16.0 SP6
"Hello All:



Anyone out there that has installed and is running with 16.0 SP6 yet? I have
a client that I am going to upgrade and I want to go to the very latest, but
we don't want to be on the bleeding edge.



William M. Allen, Jr.

ARCH Consulting Associates, Ltd.

(704) 641-0296
"
IDMS Public Discussion Forum
IDMS-L@LISTSERV.IUASSN.COM
SMTP
IDMS-L@LISTSERV.IUASSN.COM
IDMS-L@LISTSERV.IUASSN.COM
SMTP








Normal

Normal
IDMS 16.0 SP6
"Bill,

I'm past it via apars on all but one prodcution system, which is just
one APAR behind SP6. I'm scheduling the 30 most recent apars for the
final large production system on leap day, which will take me thru
QO94066. I don't actually have all of them on, but all the serious ones
that apply to our (non-SQL) environment and those that come along due to
being in affected modules. We've been very stable, but I feel a lot
better knowing we have made the necessary changes to our dump pool so
that I can again capture SVC dumps from out large production back-end.
Fortunately, we had no problems while we were vulnerable.

John, Cleveland Clinic

Outcomes