meridian99
MIS
Hello all,
I have a date formatting issue and would ask for some sql help. I have a oracle field that is a varchar2 in a table that stores a birth_date value as text in the format of mm/dd/yy as text. I would like to re-format the value into mm/dd/yyyy to include the century and leave it as text. Is there a sql scripting that would perform this? Or do I have to change the table field to a date type.
thanks
I have a date formatting issue and would ask for some sql help. I have a oracle field that is a varchar2 in a table that stores a birth_date value as text in the format of mm/dd/yy as text. I would like to re-format the value into mm/dd/yyyy to include the century and leave it as text. Is there a sql scripting that would perform this? Or do I have to change the table field to a date type.
thanks