From MohanR@STARS-SMI.com Wed, 28 Mar 2001 09:36:01 -0800 From: "Mohan, Ross" Date: Wed, 28 Mar 2001 09:36:01 -0800 Subject: OFFTOPIC RE: sqlplus Message-ID: MIME-Version: 1.0 Content-Type: text/plain Title: OFFTOPIC RE: sqlplus This post would have been ALOT funnier, if Ravindra's name was, instead, "Ganesh". (Sorry about all you folks that don't like Hindu Mythology based puns.) -----Original Message----- From: Bala, Prakash [mailto:prakash.bala@cingular.com] Sent: Wednesday, March 28, 2001 11:26 AM To: Multiple recipients of list ORACLE-L Subject: RE: sqlplus Ravindra, try using 'trunc' on your group by clause. -----Original Message----- Sent: Wednesday, March 14, 2001 7:11 PM To: Multiple recipients of list ORACLE-L Can we use the group by clause on a date column.I am written a query to get a count(*) of records with a group by clause on the date column and with date b/w two specified dates.but the query just keep executing w/o  giving any o/p or errors.The date field will also have the timestamp.Will this be a problem. I also tried with using the to_char but no success. How do i get the o/p. EX:The requirement is like say in a table with phone call info we want to display the count of call made b/w two dates in a month and grouped by date. Thanks Ravindra -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Ravindra Basavaraja   INET: ravindra@sentica.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing). -- Please see the official ORACLE-L FAQ: http://www.orafaq.com -- Author: Bala, Prakash   INET: prakash.bala@cingular.com Fat City Network Services    -- (858) 538-5051  FAX: (858) 538-5051 San Diego, California        -- Public Internet access / Mailing Lists -------------------------------------------------------------------- To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru@fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from).  You may also send the HELP command for other information (like subscribing).