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

Home -> Community -> Usenet -> c.d.o.tools -> Date format conversion

Date format conversion

From: <clewis_at_epylon.com>
Date: Thu, 04 Jan 2001 19:37:37 GMT
Message-ID: <932jdv$r43$1@nnrp1.deja.com> 






I'm currently selecting and grouping by a datetime field, which of
course is listing each row individually.



If I want to group by just the day, what is the syntax for formatting
the datetime field to return the date without the time?  And isn't this
done in the select statement?



Thanks!





Sent via Deja.com


http://www.deja.com/
Received on Thu Jan 04 2001 - 13:37:37 CST












Original text of this message













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