Re: PL/SQL setting date format

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