Date Question

OK you Oracle gurus,

This is probably an easy one for all of you but I am stumped. I need to round April 12, 1971 to the nearest month. (I guess dates after the 15th of the month are rounded forward).

Also how can I sum dates i.e.

Items were sold on 1/1/97, 1/4/97

So I should get a count of 2

Help. Thanks a bunch in advance.

Sam Lakkundi‰

-----------== Posted via Deja News, The Discussion Network ==---------- http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own Received on Tue Nov 03 1998 - 08:13:24 CST