Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.misc -> Re: TO_CHAR and TO_DATE question

Re: TO_CHAR and TO_DATE question

From: Steven Franklin <steven.franklin_at_wcom.com>
Date: Wed, 09 Jun 1999 13:03:47 GMT
Message-ID: <375E6661.1F9DE64E@wcom.com>

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

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US