[Solved] Can i insert date in mySQL in “DD-Mon-YY” format”?

Question

Mysql support this format YYYY-MM-DD by default.
But what if i want to insert date in this format “dd-Mon-yyyy” in mysql??

Is there any way so that i can insert the manual date in this format.Anyone having any idea??

If possible please write down the insert statement.

||

Answer 1

Solution #1:

Yes using MySql STRING_TO_DATE() function

insert into your_table(date_column) values(STR_TO_DATE("09-Sep-2014","%d-%b-%Y"));

Answer 2

Solution #2:

Try This Format:-

SELECT DATE_FORMAT(NOW(),'%d-%b-%Y')

This will result as:-

10-Sep-2014

Hope this will helpful to you.