Re: first of the year

From: Turkbear <john.g_at_dot.spamfree.com>
Date: Wed, 07 Jan 2004 09:29:13 -0600
Message-ID: <1d9ovv4du9gggmoihu8ti3umvnhd8qcm7c@4ax.com>

"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote:

>though
>
>SQL> select trunc(sysdate,'YEAR') from dual;
>
>TRUNC(SYSDATE,'YEAR')
>-------------------------
>08 Thoul Ki'Dah 1424
>
>might suprise the application designer from time to time.
>
>
>--
>Niall Litchfield
>Oracle DBA
>Audit Commission UK

Yep..Sometimes we forget that not all calendars are the same.. Received on Wed Jan 07 2004 - 09:29:13 CST