getting sql info for the current month

have a table that has one field that has a timestamp and through the time() 11digit information, how would you pull only the sql information from the current month.

i havn't worked with time information like this before, so don't even know where to start.

[Free WordPress Themes]

try "SELECT MONTH( NOW( ) ) "

[Join us @ facebook]

or you can use php's date function like this :

echo date('m', $timestamp);

[Guest]

[36.301]

Googlebot, Yahoo crawler, adsense, Msnbot, Baidu Spider