JDE Time Format

I am querying F91300 (Job Header) and I am looking and the Scheduler Start and End time fields but they appear to be formatted in some way. An exmaple of the what I am seeing is 17304090. Does anyone know how to convert this to human time?
I am using JDE OneWorld XE.

Hi Marshy,

Whatever we see in UTB, thats the converted format of Date and Time for user friendly.
If you want to see the actual record in database then unchecked the formatted checkbox while opening the table, so it will display you the actual format.

Here the Julian Conversion to Numeric Unformatted data value:

First 3 digits: current year - 1900
Next 3 digits: Difference of No of days between current date with 1st day of the year.

so you will get some thing like 107062 for today's date.

Hope I have answered your query.


Imran Shaikh
9819234677 (Mob)

Hi Marshy,

First of all, you are welcome aboard of JDEList.

Use the B9800188 "Format MathNumeric to Time String" Business Function.
You can check Job Schedule form (P91300/W91300F), how do it use in the Write Grid Libne - Before event.

Regards,

Zoltán

If you look at those data items in the Data Dictionary, it says they are
ANSI C UTC Time. If you look at the glossary text for those DD items, it
explains exactly what that means.



Ellen Deak

Senior Systems Developer

Cooper Standard Automotive

JDE EnterpriseOne (OneWorld XE Update 7 SP23_M1), AS400 DB2 V5R3M0,
Citrix Clients

Zoltán,

The scheduler uses Universal Time Coordinates (UTC), the number of seconds elapsed since Midnight January 1, 1970 in Greenwich, England.

You suggested the wrong business function. Use B9800009.

It contains the following time functions:

Get UTC Time
Get Time/Date from UTC
Convert UTC Time To Local Time
Get Current UTC Time
Manage UTC Daylight Savings Cache

Hi Ray,

Thanks for the correction.

I really hope, I did not misslead Marshy and nobody else.

Regards,

Zoltán