Date("Y", $date)

[latemodern]

Ha. I started a bit of a debate I see.

Thanks a lot for your help.

Here's another:

echo '
<h1>'.$row['start_time'].'</h1>';
$d = date("d", $row['start_time']);
$m = date("m", $row['start_time']);
$y = date("Y", $row['start_time']);
echo '<h1>'.$y.'</h1>';

For some reason the two headings read:

2006-03-31 20:30:00
1969

How come my year is coming out as 1969 after I use the date("Y", ) function on it? Any ideas?

Thanks again

Chris

[latemodern]

Hi

I am getting a strange result from the script below:

echo '
<h1>'.$row['start_time'].'</h1>';
$d = date("d", $row['start_time']);
$m = date("m", $row['start_time']);
$y = date("Y", $row['start_time']);
echo '<h1>'.$y.'</h1>';

For some reason the two headings read:

2006-03-31 20:30:00
1969

How come my year is coming out as 1969 after I use the date("Y", ) function on it? Any ideas?

Cheers

Chris

[laserlight]

As MarkR pointed out, you need to convert the date to a timestamp first.

$timestamp = strtotime("2006-03-31 20:30:00");
$d = date("d", $timestamp);
$m = date("m", $timestamp);
$y = date("Y", $timestamp);
echo '<h1>'.$y.'</h1>';

[Stasonis]

Because $row['start_time'] is a MySQL timestamp, not a UNIX timestamp. The date() function uses UNIX timestamps. When selecting the date from the database you can select UNIX_TIMESTAMP(start_date) if you are using MySQL. I don't know if this function works with other DB's

[bradgrafelman]

If not, just use PHP's [man]strtotime/man function.

EDIT: Cross-post link

[Weedpacket]

laserlight wrote:

As MarkR pointed out, you need to convert the date to a timestamp first.

Of course, any decent DBMS with date/time types would include functions for converting them to and from standard formats.