Re: Rounding Date to Beginning of Year

This rounds up to 1st of following year after July 1, according to Oracle documenation.

I'm looking for something that will arounds round up to 1st of year given any date, even for dates beyond July 1.

I should have explained that in my initial post. Sorry about that.

bdragos wrote:

> SELECT trunc(SYSDATE, 'YYYY') FROM dual
>
> "Terry Coccoli" <request_at_ifneeded.com> wrote in message
> news:f826c.10952613$Of.1835450_at_news.easynews.com...
>

>>Anyone have a simple method of doing this, using a minimal amount of
>>functions ?
>>