Select time frame

I have the time as 1329978937.
How do I select from mysql each entry added this month?

 

Hi, this is how to convert that time to mysql timestamp:

strftime('%Y-%m-%d %H:%M:%S', $unix_timestamp);

PHP:

To get current month use:

strftime('%Y-%m', $unix_timestamp);

PHP:

 

I know how to change before echoing but how do I tell to mysql that I need to select all the entries added this month?

 

Okay.. this works..

SELECT 
  FROM_UNIXTIME(date, '%M') AS month
FROM
 PSW_members
WHERE
  FROM_UNIXTIME(date, '%M') = 'February';

Code (markup):

 

But that is not universal. Try this:

  FROM_UNIXTIME(date, '%M') AS month
FROM
 PSW_members
WHERE
 month = FROM_UNIXTIME(NOW() + 0, '%M');

Code (markup):

 

I had it like this:

WHERE FROM_UNIXTIME(time, '%M') = '".date("M")."'

 

oh, then ok