day from date

[sateeshs]

Hi all,
Please tell me how to find out day(Monday, Tuesday etc) given a date.

Thanks,
sateeshs

[GLS400]

Re: day from date

Hi sateeshs:

Take a look at this post:

http://www.code400.com/funwithdates.php

That should give you some ideas.

Best of Luck
GLS

[B.Hauser]

Re: day from date

Hi,

the easiest way is to use embedded SQL.
SQL delivers several scalar functions to determine the day of week.

• DAYOFWEEK(Date): Returns the day of week from a date where sunday=1 and saturday = 7
• DAYOFWEEK_ISO(Date): Returns the day of week according to ISO guidelines, that means Monday = 1 and Sunday = 7
• DAYNAME(Date): Returns the name of the week day

Some times ago I wrote an article for Centerfield about SQL date functions and how to use them in RPG:
http://www.centerfieldtechnology.com/publications/archive/Aug%202006A.pdf
Page 4

Birgitta

[Mercury]

Re: day from date

Euh, Birgitta,

# DAYOFWEEK(Date): Returns the day of week from a date where sunday=1 and saturday = 1
# DAYOFWEEK(Date): Returns the day of week according to ISO guidelines, that means Monday = 1 and Sunday = 1

IMHO, if I'm not mistaken, shouldn't that be

#DAYOFWEEK(Date): Returns the day of week from a date where sunday=1 and saturday = 7
#DAYOFWEEK_ISO(Date): Returns the day of week according to ISO guidelines, that means Monday = 1 and Sunday = 7

[FaStOnE]

Re: day from date

RUN FOR THE HILLS!!!! HE CORRECTED BIRGITTA!!!

OMG!!! LOCUSTS WILL INHABIT OUR CARCASES AND FIRE WILL CONSUME US! AHHHHHHHHHHHHHHHHHHH!!!

[B.Hauser]

Re: day from date

RUN FOR THE HILLS!!!! HE CORRECTED BIRGITTA!!!

It was only a test, to see if someone reads my comments
Post corrected!

Birgitta