How To Get A Date… Out Of E1
No this is not a dating service!
Today we will cover the proprietary date format that is used in most of the files in E1.
Well, let’s just dive in…
Today’s date is 4-5-2007. In E1-land that is 107095.
Here’s the breakdown:
- E1 Date: 107095
- Year: 1900 + 107 = 2007
- Date: 095
- The 95th day of the year (2007) = April 5th
- Complete Date: April 5th 2007
Hey! What about the time?
- E1 Time: 90154
- 9:01:54 AM
- E1 Time: 210154
- 21:01:54 = 9:01:54 PM
Here is a page I put together that uses javascript to retrieve the dates.
Author
Stewart Schatz
Average Rating
2 thoughts on “How To Get A Date… Out Of E1”
Leave a Reply Cancel reply
This site uses Akismet to reduce spam. Learn how your comment data is processed.
More Stories
How to Print a Directory Structure Using PowerShell: Step-by-Step Guide
If you need to print out the directory structure and list the files within, this PowerShell script will help you...
Windows God Mode… What!?!
Windows God Mode is a hidden feature in the Windows operating system that allows users to access all of the system’s control panel options and settings in a single place.
How To Test A SQL Server Connection
There is an easy way to test your SQL Server connection when running Windows without any special software. I found...
4 Lines To Export Outlook Rules To Excel/CSV Using PowerShell
I used to use a ton of Outlook Rules to organize the thousands of emails that I receive each day....
Get The Size & Record Count Of All Tables In A SQL Server Database
Use the SQL query below to display the size and record count of all tables in an SQL Server database....
How To Get AS400/iSeries Job Queue Information Using SQL
I received a request the other day about the JD Edwards EnterpriseOne job queues and what the maximum number of...
Thank you for your post on getting dates; however I’m kind of stranded when trying to convert this number (95832) field to time in (‘HH24:MI:SS’) format such that i get 9:58:32 as output instead of 09:58:32.
My query was SELECT TO_CHAR(TO_DATE(JCSBMTIME,’HH24:MI:SS’),’HH24:MI:SS’) AS Time FROM SVM900E1.F986110 where JCJOBNBR = ‘48444’, but its throwing the error ORA-01850 hour must be between 0 and 23.
Help me solve it.
Hey, Elizabeth! Glad this site is helping you out. I think what you are looking for is something like this: