Re: TRUNC function in ORACLE?

From: Mark Gumbs <mgumbs_at_nospam.hotmail.com>
Date: Thu, 3 Jun 1999 14:20:08 +0100
Message-ID: <37567ec1.0_at_145.227.194.253>


Have you got code examples which we can try?

M

hoyt_chen_at_my-deja.com wrote in message <7j3pn8$otd$1_at_nnrp1.deja.com>...
>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.
Received on Thu Jun 03 1999 - 15:20:08 CEST

Original text of this message