Re: TRUNC function in ORACLE?

It's wrong. The correct answer is what you are seeing.

Brian

On Wed, 02 Jun 1999 17:30:16 GMT, hoyt_chen_at_my-deja.com wrote:

>Hi there:
>I got a problem when I use TRUNC function on a date data in Forms 4.5:
>
>1. I searched the Oracle Manual "PL/SQL User's Guide and Reference
>Version 1.0" (Part No.800-V1.0) and "ORACLE8 PL/SQL Programming" by
>Scott Urman. Both of them indicated that TRUNC function will return the
>"July 1" of the year if you give the format in
>'SYYY','YYYY','Year','SYEAR','YYY','YY' or 'Y'. But actually it returns
>the "January 1" of the Year. Similar problems are with the formats in
>"Q" - Quarter and "Mon" - Month, they always return the first day of the
>indicated date period.
>
>2. The format "YYYY" doesn't work!
>
>My platform:
> client: Windows NT 4.0, Oracle Forms 4.5
> Server: Oracle 7
>
>Has ORACLE changed the TRUNC's definition, or it's just kept the typos
>in their books for so many years?
>
>Thx,
>
>HC
>
>
>Sent via Deja.com http://www.deja.com/
>Share what you know. Learn what you don't.

Good Luck! Brian_RestonVA
Oracle GEHS
The opinions expressed are mine and do not necessarily reflect those of Oracle Corporation. Received on Sun Jun 06 1999 - 03:55:47 CEST