MySQL Forums
Forum List  »  Newbie

How to convert existing date values in different format
Posted by: Pramod Patki
Date: November 06, 2014 12:37PM

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.

Options: ReplyQuote




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.