Mega Code Archive

 

Categories / Oracle PLSQL / Data Type

 

Assign date value as string to date type variable

SQL> Declare   2           myDate   date;   3  Begin   4           myDate := '29-SEP-2005';   5           dbms_output.putline(myDate); --show date   6  End;   7  / SQL>