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( ) ) "

[Promote your blog for free....]

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

echo date('m', $timestamp);

[Guest]

[34.931]

Yahoo crawler, Googlebot, YMC, Baidu Spider