Date format

[moisesbr]

Hi, I have some doubts as date  format is displayed is 2013-07-25  yy/mm/dd, as it is in database.

 

1-How/is it possible to format dd/mm/yy in database ?

 

2-How to format dd/mm/yy in HTML.

3- Is it right to format it dd/mm/yy  in database, or is it mandatory it to be  yy/mm/dd and being formated at display moment ?

Regards

Moises

[Barand]

Continue to save dates in your database as yyyy-mm-dd as other formats are useless for date comparisons, sorting and use of mysql date functions.

 

To output as dd/mm/yy you have 2 options

 

1. format in the query using DATE_FORMAT() function in mysql

 

SELECT DATE_FORMAT(datefield, '%d/%m/%y') as date ...

 

2. use php date() function

 

echo date('d/m/y', strtotime($dbdate));

[moisesbr]

I used, echo date('d/m/y', strtotime($dbdate)); 

 

 

It worked but returns 2 digits year.

I would like to set year to 4 digits.

[Barand]

use 'd/m/Y' then

 

see date