Xref: alice comp.databases.oracle.server:83153 Path: alice!news-feed.fnsi.net!news.idt.net!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!remarQ70!remarQ.com!supernews.com!remarQ69!WReNclone!WReNphoon4.POSTED!WReN!not-for-mail From: nil Subject: Re: PL/SQL setting date format Newsgroups: comp.databases.oracle.server Message-ID: <1742d8f6.990d5b38@usw-ex0110-075.remarq.com> Lines: 20 Bytes: 439 X-Originating-Host: 205.160.128.129 Organization: http://www.remarq.com: The World's Usenet/Discussions Start Here References: <87a5im$t9$1@nnrp1.deja.com> X-Wren-Trace: eBE0HB0EQwlCXxYYA1AcHSMKDgAZFFgLWh4RH1hXWARQRgdAUQBWR1NBR00= Date: Wed, 02 Feb 2000 14:20:02 -0800 X-Complaints-To: wrenabuse@remarq.com X-Trace: WReNphoon4 949526841 10.0.2.75 (Wed, 02 Feb 2000 13:27:21 PST) NNTP-Posting-Date: Wed, 02 Feb 2000 13:27:21 PST this is what i get, 1 declare 2 v varchar2(40); 3 begin 4 select to_char(sysdate,'mmddyyyy') into v from dual; 5 dbms_output.put_line(v); 6* end; SQL> / 02022000 PL/SQL procedure successfully completed. SQL> looks like some type error for you. * Sent from AltaVista http://www.altavista.com Where you can also find related Web Pages, Images, Audios, Videos, News, and Shopping. Smart is Beautiful