Converting Date fromat to MySQL

Getting help Questions
1

I have a date column with format DD.MM.YY. But in MySQL the date fomat YYYY-MM-DD. How could I convert the date format before saving it to database and revert back when loading from database to handontable?

2

Hi @dassoubarna

you can still have data format correct with your database but show other format. Here’s an example: http://jsfiddle.net/mr52uvbq/

3

Thanks! It’s very helpful.

4

Great, glad I could help!