Re: Converting Date to char inPL/SQL?

Try this

...
cDatumOld Varchar2(10);
...

Hth

Miguel

frank wrote:

> 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:54:58 CST