Re: Simple Data warehouse question (cursor)

From: James <nospamheredude_at_yahoo.com>
Date: Mon, 26 Apr 2004 07:16:47 +0000 (UTC)
Message-ID: <c6id0v$o5c$1@titan.btinternet.com>

"Daniel Morgan" <damorgan_at_x.washington.edu> wrote in message news:1082934267.47754_at_yasure...
> James wrote:
>
> >>But to answer your question ... look at the options available
> >>with TO_CHAR at http://tahiti.oracle.com.
> >>--
> >
> > After looking at the documentation I don't see how any of to_char's
options
> > could help me with this problem.
>
> SELECT TO_CHAR(SYSDATE, 'MM') FROM dual;
> SELECT TO_CHAR(SYSDATE, 'MON') FROM dual;
> SELECT TO_CHAR(SYSDATE, 'D') FROM dual;
> SELECT TO_CHAR(SYSDATE, 'DD') FROM dual;
> SELECT TO_CHAR(SYSDATE, 'DAY') FROM dual;

In your first post, I thought you were implying that to_char could help with the problem I was having with my loop.

But thanks, that is a help. Received on Mon Apr 26 2004 - 02:16:47 CDT