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

Home -> Community -> Usenet -> c.d.o.tools -> Assign date value to date variable

Assign date value to date variable

From: <genenatalie_at_my-deja.com>
Date: Thu, 09 Nov 2000 21:46:09 GMT
Message-ID: <8uf5ut$i3s$1@nnrp1.deja.com>

I'm new Oracle and trying to assign a value to a date variable and then print this value out as follows;

declare d1 DATE;

    d1 := TO_DATE('01062000',"MMDDYYYY"); begin

    dbms_output.put_line (to_char(d1, 'mm/dd/yyyy')); end;

and get error ORA-06550, how do I do something as seemingly simple as this?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Thu Nov 09 2000 - 15:46:09 CST

Original text of this message

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