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.
More Stories
Quick Tip: Hold All JDE Job Queues
The following SQL statement will put all JDE Job Queues on hold: UPDATE SY920.F986130 SET QCQUSTS='02' This statement is very...
How To Disable Client Package Deployment
If you have a development client that has been neglected and JDE wants you to install 15 update packages but...
Quick Tip: Limit The Number Of Rows Returned From A SQL Query
This is pretty basic, but I had to look up the syntax to use for SQL on IBM DB2 so...
Quick Tip: Where Is An Application On The Menu?
The following SQL will give you a good idea if an application or UBE is on the menu and where...
Quick Tip: Decline All Update Packages Using SQL
A quick way to decline all packages that have been marked for deployment on a development client is use SQL:...
Quick Tip: Change A Scheduled Job’s Time Zone Using SQL
If you work with multiple time zones, especially if one uses Daylight Saving Time and the other does not, it...
Average Rating