Storing a date as *mdy from an *outfile when executing strqmqry

75 pts.
Tags:
iSeries v5
STRQMQRY
I have a date coming in to a query in *iso format. when I put it into a date field it comes back as y/m/d despite the fact my datfmt is set to *mdy

Software/Hardware used:
iseries v5.3. sql.

Answer Wiki

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

Discuss This Question: 3  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
    i have a date coming in to a query in *iso format.   What do you mean by "coming into a query in *iso format"? Firxt, where is it coming from? Is it coming from a Date field? If it is, it's not in *ISO format. The *ISO format is only for presentation. Or is it a Char field with a date value? If it is, it's not a 'date' and the format is irrelevant except for how your coding might parse it.   when i put it into a date field it comes back as y/m/d...   What do you mean by "it comes back"? Back to where?   ...despite the fact my datfmt is set to *mdy   What do you mean by "[your] datfmt"? Is that a job DATFMT()? Is it in a program? Somewhere else?   Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    The solution is temporary. There will be other problems. You can find a number of problems discussed in this forum and in just about any similar forum on the internet.   There are a number of plain SMTP free e-mail solutions that do not require use of SNDDST nor QDLS. Maybe the most common is Mime&Mail for IBM System i from Easy400. Java e-mail has also become fairly common, and other solutions exist. SMTP e-mail can also be done without any 3rd-party utilities by calling the native SMTP functions, but most sites prefer a utility.   SNDDST plus QDLS is a useful short-term function. For continuing long-term use, you need to use features that are appropriate to the task.   Tom
    125,585 pointsBadges:
    report
  • TomLiotta
    Ignore my previous comment... posted in wrong thread. -- 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