Results 1 to 2 of 2

Thread: Time Convesion

  1. #1

    [Solved] Time Convesion

    Dear All,

    anyone knows business function to quickly convert time.

    The example is like:

    My table has TDAY with content:
    9 means "00:00:09"
    30 means "00:00:30"
    123 means "00:01:23"
    3350 means "00:33:50"
    93429 means "09:34:29"
    235500 means "23:55:00"

    If possible, i don't want to use the "if - lenght - substr - concat" way, it's too long.

    So anyone knows a business function to do that? OR any short way to do that.

    Thank you very much


    =============================edit by Me 07/11/19

    I user B9800188

    bf.jpg

    Thanks all
    Last edited by erricksandesu; 11-06-2019 at 08:50 PM.

  2. #2
    Senior Member craig_welton's Avatar
    Join Date
    Oct 2000
    Location
    Litchfield, CT
    Posts
    1,027
    B986110B.FormatTimeWithColons
    Craig Welton
    PatWel Group Inc.
    http://www.patwel.com
    Home of the FREE JDE Object Browser, JDETrace, NERDup and BusBuild+ Tools

    E1 9.0 8.98.4.2 Wintel SQL 2008
    E1 9.2 9.2.1.4 iSeries

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
The legal restrictions and terms of use applicable to this site are available here.
Use of this site signifies your agreement to the terms of use.
JDELIST is NOT affiliated with JD Edwards® & Company, Oracle or Peoplesoft. Contents of this site are neither endorsed nor approved by JD Edwards® & Company and, or Oracle.