[SOLVED] How do I display just the year with a datetime field?

[limitphp]

I have a datetime field in mysql.  On a certain page, I just want to display the year only.  How do i do that?

 

 

[rhodesa]

<?php
  $date = '2009-01-05 12:34:35';

  print date('Y',strtotime($date));
  //or
  list($year) = explode('-',$date);
  print $year;
?>

[flyhoney]

echo date('Y', strtotime($mysql_datetime));

[premiso]

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

 

SELECT date_format(`datefield`, '%Y') FROM table_name

 

 

[limitphp]

thanks!

[sniperscope]

You can use substr() also.

 

$current_date = $row['date_time_field'];
$year = substr($current_date, 0, 10); //we assume your time stamp is 0000/00/00 00:00:00
echo $year;  // so we have 0000/00/00 for output.

[premiso]

Just a side note for you limit, pulling it out of MySQL in the correct format is the preferred way as it is more efficient and produces much less code. If you want to add more code, I would go with flyhoney's way.

 

Just an fyi =) (Why write code to process it when you can pull it out exactly how you need it?)

 

[limitphp]

Just a side note for you limit, pulling it out of MySQL in the correct format is the preferred way as it is more efficient and produces much less code. If you want to add more code, I would go with flyhoney's way.

 

Just an fyi =) (Why write code to process it when you can pull it out exactly how you need it?)

 

 

How would I pull just the year out of the table?  Yes, its in 2008-11-02 08:10:25 format.

[premiso]

http://dev.mysql.com/doc/refman/5.1/en/date-and-time-functions.html#function_date-format

 

SELECT date_format(`datefield`, '%Y') FROM table_name

 

 

 

 

ummm....see above?

[rhodesa]

SELECT date_format(`datefield`, '%Y') FROM table_name

 

agreed