need help on getting day of the week for given date

110 pts.
Tags:
RPGLE
I am using the below sql to get the day of week but i am getting :NumWeekDay as 0 I am using V5R3...can some help me on this to get the day of week. C/Exec SQL Set :NumWeekDay = DayOfWeek_ISO(:MyDate) C/End-Exec the above sql to get the day of week

Software/Hardware used:
software

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
  • ToddN2000
    What is the value of the date you are trying to determine ? It looks like MyDate but I dont see that value getting loaded. Maybe it's just me but it seems like some code may be missing.  
    13,310 pointsBadges:
    report
  • philpl1jb
    It depends what type of field and what data is in MYDATE. 
    50,595 pointsBadges:
    report
  • TomLiotta
    Also, what are the values of SQLSTATE/SQLCODE after the SET statement? We don't know your variable values and we don't know what SQL reported. It's effectively impossible to come up with a useful answer. 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