Re: format dates from a database

have a look at date_format() in mysql. there is quite a few date format functions that will allow you to format dates coming out of mysql. DATE_FORMAT(date,format) Formats the date value according to the format string. The following speci ers may be used in the format string: %M Month name (January..December) %W Weekday name (Sunday..Saturday) %D Day of the month with English sux (1st, 2nd, 3rd, etc.) %Y Year, numeric, 4 digits %y Year, numeric, 2 digits %X Year for the week where Sunday is the rst day of the week, numeric, 4 digits, used with '%V' %x Year for the week, where Monday is the rst day of the week, numeric, 4 digits, used with '%v' %a Abbreviated weekday name (Sun..Sat) %d Day of the month, numeric (00..31) %e Day of the month, numeric (0..31) %m Month, numeric (01..12) %c Month, numeric (1..12) %b Abbreviated month name (Jan..Dec) %j Day of year (001..366) %H Hour (00..23) %k Hour (0..23) %h Hour (01..12) %I Hour (01..12) %l Hour (1..12) %i Minutes, numeric (00..59) %r Time, 12-hour (hh:mm:ss [AP]M) %T Time, 24-hour (hh:mm:ss) %S Seconds (00..59) %s Seconds (00..59) %p AM or PM %w Day of the week (0=Sunday..6=Saturday) %U Week (0..53), where Sunday is the rst day of the week %u Week (0..53), where Monday is the rst day of the week %V Week (1..53), where Sunday is the rst day of the week. Used with '%X' %v Week (1..53), where Monday is the rst day of the week. Used with '%x' %% A literal `%'. All other characters are just copied to the result without interpretation: mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%W %M %Y'); -> 'Saturday October 1997' mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H:%i:%s'); -> '22:23:00' mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%D %y %a %d %m %b %j'); -> '4th 97 Sat 04 10 Oct 277' mysql> select DATE_FORMAT('1997-10-04 22:23:00', '%H %k %I %r %T %S %w'); -> '22 22 10 10:23:00 PM 22:23:00 00 6' mysql> select DATE_FORMAT('1999-01-01', '%X %V'); -> '1998 52' As of MySQL Version 3.23, the `%' character is required before format speci er characters. In earlier versions of MySQL, `%' was optional. Steve "Caleb Walker" <cwalker@cwalk.org> wrote in message news:01081813054602.05392@butthead.cwalk.org... > I am wondering if there is an easier way to format dates that come out of a > database. My database stores my date in the format- "YYYY-MM-DD". I know > that I can take this and rearrange it with some string manipulation but is > there any other easier way to do that say like making it say Sep. 09, 2001 > instead of 2001-09-09 without using ereg()? > > Thanks for your help