Results 1 to 4 of 4

Thread: Generate milliseconds since 1970 (Epoch)

  1. #1

    Exclamation Generate milliseconds since 1970 (Epoch)

    I need to create a column in a JDE table which is a numeric value denoting the number of milliseconds since 1970 when a row is inserted and there doesn't seem to be an existing business function that will generate that based on the current date and time. Any assistance would be appreciated.

  2. #2
    Try this:

    1. Use B9800009/GetCurrentUTCTimeWithSeconds to get the current time.
    2. Use B90CG010/ConvertUserDateandTimetoUTC to convert 1/1/1970 to UTC.
    3. Use B95900/GetSecondsBetweenUTimes to get the difference between 1/1/1970 and the current time. Multiply into 1000 to get milliseconds.

    Hari Sharma
    EnterpriseOne: Integration (.Net, Web Services) | Output Management | Monitoring

  3. #3
    Thank you for the help Hari. I will give that a try.

  4. #4
    I need to know if there is a bsfn where I can get the milliseconds when inserting in a custom table

    From already thank you very much

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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.