need help on getting day of the week for given date

SOW
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
Asked:
Related Questions

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.

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.
  • 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.  
    99,840 pointsBadges:
    report
  • philpl1jb
    It depends what type of field and what data is in MYDATE. 
    54,090 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.

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

Following

Share this item with your network: