[leonaze31]

Hi,

I don't understand why my dates save in DB with the format yyyy-mm-dd ?

In Grocery CRUD config i do this :

$config['grocery_crud_date_format] = 'uk-date';

I load a french translation for the datepicker with :

dateFormat: 'dd/mm/yy'

But in my DB i have like that : 2012-09-21

Thanks for the answers.

[saulimus]

Because your DB stores the date in that format.
http://dev.mysql.com...n/datetime.html

[leonaze31]

Thanks. But I try to make my date to a varchar in db and do change_field_type to date but it don't works.

There is a solution ?

[saulimus]

Umm, why would you? That's what the sql date type is meant for..

[leonaze31]

Because I just need the date to display it in this format "dd/mm/YYYY" and I don't understand why a varchar is interpreted like a date.

So I do this in php thanks for the reply.

[Andrea Pagliarani]

I have same problem.
I need the date to display it in this format "dd/mm/YYYY".

Have you solved the problem?

[victor]

http://stackoverflow.com/questions/2487921/convert-date-format-yyyy-mm-dd-dd-mm-yyyy