Xref: alice comp.databases.oracle.misc:32874 comp.databases.oracle.tools:26027
Path: alice!news-feed.fnsi.net!news.idt.net!newsfeed.mathworks.com!newsfeed1.earthlink.net!nntp.earthlink.net!posted-from-earthlink!not-for-mail
From: beverett@earthlink.netNOSPAM (Brian Everett)
Newsgroups: comp.databases.oracle.misc,comp.databases.oracle.tools
Subject: Re: TRUNC function in ORACLE?
Date: Sun, 06 Jun 1999 01:55:47 GMT
Content-Transfer-Encoding: 7bit
References: <7j3pn8$otd$1@nnrp1.deja.com>
X-Posted-Path-Was: not-for-mail
Content-Type: text/plain; charset=us-ascii
X-ELN-Date: 6 Jun 1999 02:53:08 GMT
X-ELN-Insert-Date: Sat Jun  5 19:55:08 1999
Organization: EarthLink Network, Inc.
X-Newsreader: Forte Agent 1.5/32.451
Lines: 44
Mime-Version: 1.0
Message-ID: <375cd4e0.6226463@news.earthlink.net>


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

Brian

On Wed, 02 Jun 1999 17:30:16 GMT, hoyt_chen@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.