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: GROUP BY hour in a date field?

Re: GROUP BY hour in a date field?

From: Magnus Lassi <lassi_at_home.se>
Date: Sun, 04 Jul 1999 08:51:24 GMT
Message-ID: <377f202c.11614888@nntpserver.swip.net> 





thanks..it really was that simple! duh..I just had to convert it back
to date and add the format mask and then it worked perfectly..thanks
again! saved me alot of time..



>


>Have you tried 


>


>INSERT INTO dest60


>(SELECT ne,rt,TO_CHAR(measuredate,'HH24 YYY-MM-DD') 


>GROUP BY  ne, rt,TO_CHAR(measuredate,'HH24 YYY-MM-DD') )



Received on Sun Jul 04 1999 - 03:51:24 CDT












Original text of this message













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