RE: [PHP] formating date

2003-07-30 Thread Peter Knight
-Original Message- My script currently works; printing the date that it extracts from mysql table. It prints the date as: 2004-01-29 $mailed=$row[mailed]; $payment=$row[payment]; $ID=$row[ID]; echo TRTD$mailed/TDTD$payment/TD/TR; I'm trying to change the format

RE: [PHP] formating date

2003-07-30 Thread Carl Furst
You can do it by selecting the formatted date from the mysql server using the DATE_FORMAT command which would be: SELECT DATE_FORMAT('%M %D, %Y', date_field_name_or_mysqldate); -Original Message- From: Gronquist, Jim M [mailto:[EMAIL PROTECTED] Sent: Wednesday, July 30, 2003 11:53 AM