[tariquetuku]

Can anyone plz advice, how to change mysql date format to (d-m-Y) permanently
which will affect all the databases in the mysql server. i.e, i want to change the date format in one place which will affect all the database's date format automaticly?

Is there any way out? Or code?

[Atli]

Hi.

MySQL will always display Date values in the "YYYY-MM-DD" format.
You can't change that, and even if you could, it would be a horrible idea.

You can, however, use the DATE_FORMAT function to re-format the date before using it.

But I wouldn't do that. You really shouldn't alter the data your database returns. It is far more consistent to have MySQL return data in it's default format and have your application (like say PHP code) format the data before using it.

[tariquetuku]

Originally Posted by Atli

Hi.

MySQL will always display Date values in the "YYYY-MM-DD" format.
You can't change that, and even if you could, it would be a horrible idea.

You can, however, use the DATE_FORMAT function to re-format the date before using it.

But I wouldn't do that. You really shouldn't alter the data your database returns. It is far more consistent to have MySQL return data in it's default format and have your application (like say PHP code) format the data before using it.

Thanks Atli,

I get it.