How to select articles of a particular date/year from a mySQL table?

[irock]

Hi, I want to select a particular month & year (May 2004) from a SQL table that keeps track of article by a variable called 'dateline' which is a 10-digit integer. eg. 961484400

I was wondering how to write SELECT articles which are dated May 2004 from this table.

$sql = "SELECT id, article, dateline FROM articles ORDER BY dateline DESC LIMIT 3";

Thanks much!

[volatilegx]

If the dateline field is populated with Unix timestamps, then it would go something like this:

[pre]
$begindate = mktime(0,0,0,5,1,2004);
$enddate = mktime(24,59,59,5,31,2004);
$sql = "SELECT id, article, dateline FROM articles
 WHERE dateline > '".$begindate."' and dateline < '".$enddate."'
 ORDER BY dateline DESC LIMIT 3";
[/pre]

[irock]

So, does '961484400' look like an unix time stamp to you?

[coopster]

print strftime [php.net]('%c', 961484400); // 06/20/00 02:00:00