Re: Date Question

Sam

1. Try this : round(your_date,'MON')
2. You might be able to use a COUNT DISTINCT (DATE) where stuff is sold.

HTH Steve

slakkundi_at_my-dejanews.com wrote in message <71n324$444$1_at_nnrp1.dejanews.com>...
>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&#137;
>
>-----------== 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:49:11 CST