Getting a year from a MySQL timestamp

By

Keiron

– 30/04/2010Posted in: MySQL

To filter by a year when the date has been saved as a timestamp, do this. pub_date if the stored record.

$query = "SELECT FROM_UNIXTIME(pub_date, '%Y') as year FROM ".$table ." WHERE parent='177' AND deleted='0' AND FROM_UNIXTIME(pub_date, '%Y')='2010' AND published='1' ORDER BY pagetitle";

Like this? Maybe you could buy me a coffee.

Tags: database, date, MySQL, php, select, timestamp, unix

About Keiron

Web Developer based in the UK. Click here if you want to work with me

2 Comments

1. Abel Kovalovsky

   Posted May 26, 2010 at 12:53 PM

   I love the site

2. Hipolito M. Wiseman

   Posted June 25, 2010 at 7:09 AM

   Just thought i would comment and say neat design, did you code it yourself? Looks great.