How to convert existing date values in different format
Hi,
I have a table with a column New_Date in it of type varchar(16).
I have found that some dates in this column are in YYYY-MM-DD format while others are in DD/MM/YY format.
My question is - How can I change dates that are in YYYY-MM-DD format to DD/MM/YY format without changes their present value?
Thanks in advance.
Subject
Written By
Posted
How to convert existing date values in different format
November 06, 2014 12:37PM
November 06, 2014 01:13PM
November 06, 2014 02:29PM
November 06, 2014 03:38PM
November 06, 2014 04:55PM
November 06, 2014 07:22PM
November 07, 2014 06:25AM
November 07, 2014 08:43AM
November 08, 2014 09:45AM
November 06, 2014 08:55PM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.