Thanks for the quick reply Ionut,
Unfortunately I cannot the SQL which retrieves the data. So I cannot use
builtin mysql functions.
Thanks
b
Ionut Gabriel Stan wrote:
I'm not sure what kind of problem the Zend Feed
component can confront when dealing with your code,
but if I may, you can extract the date as a Unix
timestamp directly from MySQL using it's built-in
function:
UNIX_TIMESTAMP(date),
then format it in PHP with a simple:
date('r', $row->timestamp),
or you can even format an RFC 2822 compliant date
inside your query with MySQL's
DATE_FORMAT(date, format),
which works pretty much like PHP's date function.
http://dev.mysql.com/doc/refman/5.0/en/date-and-time-functions.html
--- Bill YILDIRIM <[EMAIL PROTECTED]> wrote:
Hi there,
I have been playing with Zend_Feed since yesterday.
I finally managed to
create my first rss feed. I have on problem though.
This is how I
convert mysql datetime to rss date time
$newstime = $thisProduct->addDate;
list($date, $hours) = split(' ',
$newstime);
list($year,$month,$day) =
split('-',$date);
list($hour,$min,$sec) =
split(':',$hours);
//returns the date ready for the rss
feed
$date = date('r',mktime($hour, $min,
$sec, $month, $day,
$year));
but when I reach the feed, it shows the current date
and time?
does it suppose to work like this?
Thanks
B
____________________________________________________________________________________
Looking for last minute shopping deals?
Find them fast with Yahoo! Search. http://tools.search.yahoo.com/newsearch/category.php?category=shopping
