Day of the week

gpbarsky · Post by **gpbarsky** » Thu May 27, 2004 3:57 pm

Hi, forumers.

I need to know how can I get the day of the week, using some function.

I read the ICONV and OCONV functions but I couldn't get how to use it.

Does anyone know this ?

Thanks in advance.

ray.wurlod · Post by **ray.wurlod** » Thu May 27, 2004 4:19 pm

Code: Select all

OCONV(internaldate, "DW")

returns numeric day of week (which day is day 1 depends on your locale setting).

Code: Select all

OCONV(internaldate, "DWA")

returns the alphabetic name of the day of the week.

Code: Select all

OCONV(internaldate, "DWB")

returns the abbreviated alphabetic name of the day of the week.

For more information on date conversions, read the article Date Conversion Demystified.