Posted by Gordon Burditt on 02/04/06 07:21

>I must be having a brain freeze because I can't figure out how to display
>dates older than 1970.
>
>I have birth dates stored in MySQL as "date" data types (exp. 1955-04-06).
>I'd like to display as "April 4, 1955".

I recommend formatting it with MySQL's date_format() function.

e.g.

SELECT date_format(birthdate, "%M %e, %Y") from table where ...;

MySQL's datetime format manages to cover years from 1 to 9999.

Gordon L. Burditt

[Back to original message]