Home > IT Answers > AS/400 > Converting AS/400 calender date to julian date
Aabbmadush
5 pts.
 Converting AS/400 calender date to julian date
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
ASKED: January 12, 2011  11:12 AM
UPDATED: February 15, 2011  6:49 PM
RELATED QUESTIONS
Answer Wiki:
(Isolate the year * 1000) + (number of days from Jan 1 of said year)
Last Wiki Answer Submitted:  February 15, 2011  6:49 pm  by  Modiyooch   540 pts.
All Answer Wiki Contributors:  Modiyooch   540 pts.
To see all answers submitted to the Answer Wiki: View Answer History.


RSS - Discussions Help
Discuss This Question:
_ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _ _

 

…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

TomLiotta
 107,735 pts.
 

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

TomLiotta
 107,735 pts.