DB2/400 SQL User-Defined Function for Julian date conversion

slandess

slandess

Well Known Member
All -

If your JDE database resides on the System i - iSeries - AS/400, I just posted a SQL UDF in the Downloads section of JDELIST that you might find useful.

This UDF (User-Defined Function) makes it easier with SQL to view Julian dates in JDE files - it converts them to *ISO format (YYYY-MM-DD) so you can actually read the date!

Click here to see my JDELIST Downloads posting

Regards,
 

Similar threads

A7.3 Need DB2 SQL to convert YYYYMMDD to Julian date
Replies
8
Views
3K
cazzafed
cazzafed
E9.2 Date Formats in Orchestrations and Service Requests
Replies
4
Views
5K
jolly
E9.2 Need to convert a date between a data request and form request
Replies
1
Views
3K
jesscamp6984
Getting Timestamp with miliseconds (format YYYY-MM-DD-HH.MM.SS.TTTTTT)
Replies
2
Views
4K
ONYX
ONYX
Need to figure out User Date Format from Login ID
Replies
2
Views
5K
ramalaxkar
Back
Top