Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.misc -> Re: TO_CHAR and TO_DATE question
Mark van Kerkwyk wrote:
> Hi Steve, thanks for your reply.
> The only reason why I was using to TO_CHAR was for the purposes of getting the
> Hour,Day and Month components for grouping purposes. Is there a way to group by
> Hour,Day,Month without converting with TO_CHAR ??
>
TRUNC(date,'HH24') TRUNC(date,'DD') TRUNC(date,'MM')Received on Wed Jun 09 1999 - 08:03:47 CDT