Change the date format of field in a table 2

[forostec]

Hello, i have this doubt:

How can i predifine the format of a date field so i can work comfortable, because the format is yyyy-mm-dd and i need dd-mm-yyyy.

How can i do this?

 

[cLFlaVA]

SELECT DATE_FORMAT(the_date_col, '%c-%d-%Y')

*cLFlaVA
----------------------------
Lois: "Peter, you're drunk!"
Peter: "I'm not drunk, I'm just exhausted from stayin' up all night drinking!

 

[r937]

right idea, wrong format

SELECT DATE_FORMAT(the_date_col, "%d-%m-%Y")



rudy

http://r937.com/

SQL Consulting

 

[forostec]

and this change is permanently?

 

[cLFlaVA]

?

That will display the date value as you want it using a select statement.

*cLFlaVA
----------------------------
Lois: "Peter, you're drunk!"
Peter: "I'm not drunk, I'm just exhausted from stayin' up all night drinking!