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: 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
--
PHP Database Mailing List (http://www.php.net/)
To unsubscribe, visit: http://www.php.net/unsub.php
