Sublime directory Surf the web anonymous Pagerank Monitor


getting sql info for the current month

stickdragon
Mon 24 December 2007, 08:12 am GMT +0100
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.

olaf
Mon 24 December 2007, 09:37 am GMT +0100
try "SELECT MONTH( NOW( ) ) "


Nikolas
Tue 25 December 2007, 06:12 pm GMT +0100
or you can use php's date function like this :

echo date('m'$timestamp);?>

Archive for SMF v1.00 by N.P. Valid XHTML 1.0 Transitional