How To Get A Date… Out Of E1 Part 2

Read Time:34 Sec

Don’t worry, this still is not a dating service!

My last post dealt with dates in E1. Well, there is another way that dates are stored…

The number of seconds since January 1, 1970.

This isn’t too uncommon in programming languages such as C++, but it sure is a pain in the rear-end when looking in a database.

I have included a conversion tool on my E1 Dates page.

***NOTE: the dates calculation page has been updated***

Updated:

Here is a very simple way to convert the date using SQL:

date(char(DATEFIELD+1900000))

Example:

select date(char(SCSECLST+1900000)) from sy811/f98owsec

Technorati Tags: e1,enterpriseone,erp,peoplesoft,oracle,jde,jd edwards

Author

Stewart Schatz

Career: Principal CNC Consultant for Syntax Systems Limited specializing Oracle JD Edwards EnterpriseOne and the technology that supports it. Side Hustle: Owner/Operator of E1Tips.com Location: Lancaster, PA USA  What I like to do: Invest in Family, Explore Technology, Lead Teams, Share Knowledge/Experience, Hunt, Hike, etc.
Happy
Happy
0
Sad
Sad
0
Excited
Excited
0
Sleepy
Sleepy
0
Angry
Angry
0
Surprise
Surprise
0

Average Rating

5 Star
0%
4 Star
0%
3 Star
0%
2 Star
0%
1 Star
0%

Leave a Reply

Your email address will not be published. Required fields are marked *

This site uses Akismet to reduce spam. Learn how your comment data is processed.

Previous post How To Get A Date… Out Of E1
Next post Problems Deleting An EnterpriseOne (E1) Custom Object