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 -> Re: Converting Date to char inPL/SQL?

Re: Converting Date to char inPL/SQL?

From: Nick Grossman <nick_at_ulster.net>
Date: Wed, 17 Mar 1999 11:14:30 -0800
Message-ID: <36EFFF16.59CFD4BA@ulster.net>


> 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?

If this is your actual code, you need to use the assignment operator, which is := rather than = (that's an evaluation operator)

so change this

> datumold DATE;
> cDatumold VARCHAR2(10); -- as someone suggested
>
> cDatumold = TO_CHAR(datumold,'DD.MM.YYYY');

to

datumold DATE;
cDatumold VARCHAR2(10); -- as someone suggested

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

Cheers!
Nick Grossan Received on Wed Mar 17 1999 - 13:14:30 CST

Original text of this message

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