CA IDMS IUA EIUA

Converting Date & Time

  • 1.  Converting Date & Time

    Posted 02-15-2008 07:58 AM
    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