Re: first of the year

From: Niall Litchfield <n-litchfield_at_audit-commission.gov.uk>
Date: Wed, 7 Jan 2004 14:54:44 -0000
Message-ID: <3ffc1db4$0$9387$ed9e5944@reading.news.pipex.net>

"Scott Mattes" <Scott_at_TheMattesFamily.ws> wrote in message news:Xns94696205345F1ScottatTheMattesFami_at_24.48.107.54...
> Sybrand Bakker <gooiditweg_at_sybrandb.demon.nl> wrote in
> news:9h5nvv85j4u9sbbm598msd47gtofca0un2_at_4ax.com:
> >
> >>= trunc(sysdate,'YEAR')
>
> But if run on any other day of the year problems could ensue, right?

Wrong

SQL> select sysdate from dual;

SYSDATE

---

07-JAN-04 SQL> select trunc(sysdate,'YEAR') from dual;

TRUNC(SYS

---

01-JAN-04 SQL>

-- 
Niall Litchfield
Oracle DBA
Audit Commission UK

Received on Wed Jan 07 2004 - 08:54:44 CST