Standard date format

[Stooney]

What is the most common (and preferred) date format?  I'm trying to decide unix time, mysql date format, etc.  The date is used for storing register date, birthday, last action.

[akitchin]

if you're using MySQL, there's no reason to use anything other than the DATE field type.  MySQL has a plethora of functions to manipulate the date as necessary.

[zq29]

I always use the MySQL DATE format (YYYY-MM-DD) when storing dates.

[ardyandkari]

i use mysql date format (yyyy-mm-dd) and then if i want to rearrange the numbers i split it.

[jcombs_31]

I agree, you can always format the date differently for display purposes.

[Daniel0]

ISO 8601

[JonnoTheDev]

Depends on the target country of the website. In the UK we use dd-mm-yyyy.

You could have dynamic date formatting dependent on the users location.

[akitchin]

Depends on the target country of the website. In the UK we use dd-mm-yyyy.

You could have dynamic date formatting dependent on the users location.

 

or use MySQL's DATE format, then use DATE_FORMAT() when outputting it.  which is precisely why one would probably want to use this format in the first place.

[Daniel0]

Depends on the target country of the website. In the UK we use dd-mm-yyyy.

You could have dynamic date formatting dependent on the users location.

 

That's why you should use ISO standards. International Organization for Standardization...