Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Converting Date to char inPL/SQL?

Converting Date to char inPL/SQL?

From: frank <frank_at_mediaaktiv.de>
Date: Wed, 17 Mar 1999 15:13:45 +0100
Message-ID: <36EFB899.BA8B49AE@mediaaktiv.de> 





Hi



I'd like to convert a date variable to a char/varchar2 variable.
Here's what I tried:



datumold DATE;


 cDatumold VARCHAR2;



cDatumold = TO_CHAR(datumold,'DD.MM.YYYY');



I also tried without a mask:


cDatumold = TO_CHAR(datumold);



what's wrong here?



Bye


Frank

Received on Wed Mar 17 1999 - 08:13:45 CST












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US