From oracle-l-bounce@freelists.org Thu Jan 20 12:12:26 2005 Return-Path: Received: from air891.startdedicated.com (root@localhost) by orafaq.com (8.12.10/8.12.10) with ESMTP id j0KICPJM018001 for ; Thu, 20 Jan 2005 12:12:25 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air891.startdedicated.com (8.12.10/8.12.10) with ESMTP id j0KICLxu017975 for ; Thu, 20 Jan 2005 12:12:21 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 4541772C43F; Thu, 20 Jan 2005 12:09:53 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 02575-45; Thu, 20 Jan 2005 12:09:53 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id D930172C0A3; Thu, 20 Jan 2005 12:02:38 -0500 (EST) From: "Eric Buddelmeijer" To: , "'oracle-l'" Subject: RE: Funny oracle character... Date: Thu, 20 Jan 2005 17:55:52 +0100 Organization: Elegant Application Services MIME-Version: 1.0 Content-type: text/plain; charset=iso-8859-1 Content-Transfer-Encoding: 8bit X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1441 Thread-Index: AcT/DPd7egFMuMYuSWa9fo8aWf6BfgAAgRuAAABndDA= In-Reply-To: Message-Id: <20050120165554.1138E466B1@orange.qinip.net> X-archive-position: 15007 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: Eric.Buddelmeijer@elegant.nl Precedence: normal Reply-To: Eric.Buddelmeijer@elegant.nl X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org X-Spam-Status: No, hits=0.0 required=5.0 tests=none autolearn=ham version=2.60 X-Spam-Level: X-Spam-Checker-Version: SpamAssassin 2.60 (1.212-2003-09-23-exp) on air891.startdedicated.com Sorry, Replace the second BETWEEN in my comment below by INTERVAl(DAY) and you = have something that might be true. Eric. -----Oorspronkelijk bericht----- Van: Eric Buddelmeijer [mailto:Eric.Buddelmeijer@elegant.nl]=20 Verzonden: donderdag 20 januari 2005 17:46 Aan: 'rgramolini@tax.state.vt.us'; 'oracle-l' Onderwerp: RE: Funny oracle character... I copied and pasted it from the source site into a ms-windows sqlplus executed it and came up with: DECLARE begin_time TIMESTAMP :=3D TO_TIMESTAMP('18-Sep-2002 07:35:00PM','dd-Mon-yyyy hh:mi:ssPM'); end_time TIMESTAMP :=3D TO_TIMESTAMP ('18-Sep-2002 07:35:30PM','dd-Mon-yyyy hh:mi:ssPM'); difference INTERVAL DAY TO SECOND; BEGIN difference :=3D end_time =D0 begin_time; DBMS_OUTPUT.PUT_LINE(difference); END; ORA-06550: line 9, column 28: PLS-00103: Encountered the symbol "=D0" when expecting one of the = following: . ( * @ % & =3D - + ; < / > at in is mod not rem <> or !=3D or ~=3D >=3D <=3D <> and or like between || The symbol ". was inserted before "=D0" to continue. My guess is that somewhere BETWEEN writing and publishing the article = the BETWEEN keyword got replaced by =D0. Probably some fancy xml processing = in there.=20 Kind regards, Eric. -----Oorspronkelijk bericht----- Van: oracle-l-bounce@freelists.org = [mailto:oracle-l-bounce@freelists.org] Namens Ruth Gramolini Verzonden: donderdag 20 januari 2005 17:21 Aan: oracle-l Onderwerp: FW: Funny oracle character... Good morning all, One of my developers asked me to find out what the strange symbol I have = put in bold in this line is:days_in_2000 :=3D begin_2001 =D0 begin_2000; He had seen it several times in the documentation. I can't reproduce it = to do a search. Anyone know about this? Thanks in advance, Ruth -----Original Message----- From: Stephen Peterson [mailto:speterson@tax.state.vt.us] Sent: Wednesday, January 19, 2005 4:14 PM To: Ruth Gramolini Subject: Funny oracle character... http://www.oracle.com/technology/oramag/oracle/02-nov/o62sql_online.html Using Intervals Intervals can be used for many things, but in this article I'm going to focus on datetime arithmetic. If you think about it, intervals are = really nothing new. Consider the following code, which computes the difference between two dates in order to come up with the number of days in the = year 2000: DECLARE begin_2000 DATE :=3D TO_DATE('1-Jan-2000','dd-Mon-yyyy'); begin_2001 DATE :=3D TO_DATE('1-Jan-2001','dd-Mon-yyyy'); days_in_2000 NUMBER; BEGIN days_in_2000 :=3D begin_2001 =D0 begin_2000; END; / Stephen C. Peterson System Developer II Vermont Department of Taxes 109 State St Montpelier VT, 05602 W: 802-828-3747 E: speterson@tax.state.vt.us -- http://www.freelists.org/webpage/oracle-l -- http://www.freelists.org/webpage/oracle-l