Re: day of the week

["C. Willis III" <ceprn@HOTMAIL.COM>]

Karin,

While I am not certain what you mean by 'get the number of week', or
what database and version [OS and version/ platform and version] you are
using, in Oracle, to get the day of the week in a number form (1 =
sunday?) I would use the following :

select
to_number(to_char(poh1.po_dt, 'D')) &po_week_day
from table, blah, blah, blah. [sqr fxn too]

to get the day of the week in 'fri' format:
to_char(poh1.po_dt, 'dy')    [sqr fxn too]

to get the day of the week in 'friday' format:
to_char(poh1.po_dt, 'day')   [sqr fxn too]

to get the number of the week in a year:
to_char(poh1.po_dt, 'WW')    [sqr fxn too]

to get the number of the week (in ISO format [whatever that is]) in a
year:
to_char(poh1.po_dt, 'IW')

If you are using one of those sissy databases ;-) , I can't tell you
what to use; you might have to do some fancy coding.  Look in your
datbase manual, or in the sqr language ref manual (pp212 in V4).

clark

----Original Message Follows----

I've bumped into a little problem with an SQR-report, and would really
appreciate som help.

Does anyone know how to get the number of week and the day of week from
a special date??

> //Karin



______________________________________________________
Get Your Private, Free Email at http://www.hotmail.com