Date not displaying properly

[m5884]

Hi, this might a very newbie question, but my date isn't displaying properly and I do not know why!!

I have something like this:

<?php
$sql = "SELECT * FROM db_table WHERE Bpublished = '1' AND Bcater='$passed_cater' ORDER BY Bid DESC LIMIT $ppage, $limit";
$res = mysql_query($sql,$conn); 
	while ($row_blog = mysql_fetch_array($res)) {							
		echo date('d M Y', $row_blog['Bdate']); 
	};
?>

And all the entries echo this - 31 Dec 1969

I've tried variations of it, such as

echo date('r', $row_blog['Bdate']);

or

echo date('m-d-y H:i:s', $row_blog['Bdate']);

And they all produce variations of 31 December 1969!!

I don't have any entries with that date, so why is it doing that??

I'm very frustrated and I can't seem to get any answers in google!!

Please help!!

[kaafmim]

You are facing a funny problem! The first defined date is January 1, 1970. So what you receive, the day before the first defined date in php, means that the value of $row_blog['Bdate'] is -1 .

This means that mysql is returning an error while connecting the database, reading the entry, or something else. The sure thing is that the problem is in your database query, and not the date function and format.

Good luck!

[NogDog]

More likely you are getting an empty value, a zero, or a string that evaluates as zero when converted to an integer, and your server's time zone is somewhere west of the Prime Meridian. Unless the value being returned by your query is a UNIX timestamp integer, then it is not ready to be used as the 2nd parameter for date(). You may need to convert it with something like strtotime() first:

PHP Code:

echo date('d M Y', strtotime($row_blog['Bdate']));


[m5884]

Originally Posted by kaafmim

You are facing a funny problem! The first defined date is January 1, 1970. So what you receive, the day before the first defined date in php, means that the value of $row_blog['Bdate'] is -1 .

This means that mysql is returning an error while connecting the database, reading the entry, or something else. The sure thing is that the problem is in your database query, and not the date function and format.

Good luck!

Hi kaafmim! Thank you for your reply. Is there anyway I could check for this error?

Still frustrated! hehe

[m5884]

Originally Posted by NogDog

More likely you are getting an empty value, a zero, or a string that evaluates as zero when converted to an integer, and your server's time zone is somewhere west of the Prime Meridian. Unless the value being returned by your query is a UNIX timestamp integer, then it is not ready to be used as the 2nd parameter for date(). You may need to convert it with something like strtotime() first:

PHP Code:

echo date('d M Y', strtotime($row_blog['Bdate']));


Hi NogDog! (interesting name btw )

I tried strtotime() but it returns the same value. I think my time zone setup for mySQL is correct. Because when I echo the actual date row, I get the right dates, such as 2009-11-05. It is only when I try to apply a date() format to it that it seem to stuff up!

[NogDog]

What do you get if you just echo out $row_blog['Bdate'] instead of using any of the date functions? (In other words, we need to find out what the original value is that you're using.)

[m5884]

Originally Posted by NogDog

What do you get if you just echo out $row_blog['Bdate'] instead of using any of the date functions? (In other words, we need to find out what the original value is that you're using.)

I get the correct date, such as: 2009-11-02