|
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
Navigation:
[Reply to this message]
|