How do I convert a date in text format to a proper date with AS/400 Query

25 pts.
Tags:
AS/400
AS/400 Query
I have a date 20/02/2013 which is in text format but I need to convert it to a date format with a length of 10 and decimal of L (a normal date format). Basically I need to convert 20/02/2013 which is currently in text format to an ISO date format with Query using iSeries access for Windows.

Software/Hardware used:
AS400 Query

Answer Wiki

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

I have amanged to find an online manual which illustrates how to difine the statement.

Many thanks for your thoughts.

 

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
    "...a length of 10 and decimal of L (a normal date format)." That doesn't make sense. A physical file data type of "L" will set a DATE data type for a field, but there cannot be a "decimal" attribute nor will the field have a length attribute. Since you associated this with "AS/400 Query", please include what kind of query this relates to. QM Query? SQL query? OPNQRYF? Query for iSeries? -- Tom
    125,585 pointsBadges:
    report
  • CharlieBrowne
    This is something I have done in the past, but right now I do not have access to the AS400 Querry screen.When you build your query, if I remember correctly, the 2nd selection line allow you to define new fields. Go to that screen and press F1 for HELP. There is detail instructions on how to do what you want.
    41,370 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