Re: date formatting... help

you could use DATE_FORMAT in your sql to pull them out that way without using PHP. other then that you need the date format stuff in quotes "l, d.m.Y", i think... hth "Paul Ihrig" <pihrig@columb To: <php-db@lists.php.net> us.rr.com> cc: Subject: [PHP-DB] date formatting... help 05/16/2003 09:03 AM ok so have my dates inserted into a date field in mySql db as Y-m-d or 2003-05-16 when i go to retrieve then i want to display them as Friday may 15 2003 but the formatting below doesn't seem to work <?php echo date($row_rsViewNews['newsDate'], l, d.m.Y) this <?php echo date('l, F d, Y',$row_rsViewNews['newsDate']); ?> which only shows a wierd date in 1970??? any pointers please! thanks -paul -- PHP Database Mailing List (http://www.php.net/) To unsubscribe, visit: http://www.php.net/unsub.php