RE: Day of the week

You can can a SQL procedure with the following options:

SQL Enhancements

You'll also find new SQL scalar functions in V5R1, including the following:

TimeStampDiff - Returns the estimated interval between two timestamp values
based on a specified interval.

Pi - Returns the value of Pi. 

Space - Returns a string of blanks based on the number of spaces requested.

Graphic - Returns the graphic (double-byte) string expression of a string.

Midnight_Seconds - Returns an integer representing the number of seconds
between midnight and a specified time.

Julian_Day - Returns an integer representing the number of days since the
start of the Julian calendar (January 1, 4712 B.C.).

DayOfWeek_Iso - Returns an integer representing the day of the week based on
an ISO calendar (in which Monday, and not Sunday, is considered the first
day of the week).

Week_Iso - Returns an integer representing the week of the year based on an
ISO calendar.


-----Original Message-----
From: WRamos@xxxxxxxxxxxx [mailto:WRamos@xxxxxxxxxxxx]
Sent: Monday, November 24, 2003 2:39 PM
To: MAPICS ERP System Discussion
Subject: Day of the week







Im looking to find a way to look up the day of the week using any given
date.  Does anyone have a sample routine in an RPG program that can do
this?

Thanks

_______________________________________________
This is the MAPICS ERP System Discussion (MAPICS-L) mailing list
To post a message email: MAPICS-L@xxxxxxxxxxxx
To subscribe, unsubscribe, or change list options,
visit: http://lists.midrange.com/mailman/listinfo/mapics-l
or email: MAPICS-L-request@xxxxxxxxxxxx
Before posting, please take a moment to review the archives
at http://archive.midrange.com/mapics-l.