Converting AS/400 calender date to julian date

5 pts.
Tags:
AS/400 command functions
AS/400 commands
AS/400 date format
Date conversion
How to convert calander date to julian date by using query commands?

Software/Hardware used:
AS400

Answer Wiki

Thanks. We'll let you know when a new response is added.

(Isolate the year * 1000) + (number of days from Jan 1 of said year)

Discuss This Question: 2  Replies

 
There was an error processing your information. Please try again later.
Thanks. We'll let you know when a new response is added.
Send me notifications when members answer or reply to this question.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy
  • TomLiotta
    ...by using query commands? For which query product? Query "commands" can't do anything with dates. They can only access query products, then you can create queries that may work with dates. But different query products do things differently. Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    The Query/400 product is currently called 'Query for i5/OS' or 'IBM Query for i', and it may be entered by running the WRKQRY command. The most common alternative query product is Query Manager (which can use SQL), and the STRQM command is a way to enter the product. It's also common for SQL to be used directly through the STRSQL command. There are other possibilities, but those are most likely for you. Can you describe how you get into your query function? We can determine what the product is with a little description from you. We can help better if we know which product you use and which answer to give. Tom
    125,585 pointsBadges:
    report

Forgot Password

No problem! Submit your e-mail address below. We'll send you an e-mail containing your password.

Your password has been sent to:

To follow this tag...

There was an error processing your information. Please try again later.

REGISTER or login:

Forgot Password?
By submitting you agree to receive email from TechTarget and its partners. If you reside outside of the United States, you consent to having your personal data transferred to and processed in the United States. Privacy

Thanks! We'll email you when relevant content is added and updated.

Following