[RESOLVED] php time in DB - query the month, how?

hey,

ive used php time() to store against a record... trouble is, now i need to query the database on month and year... eg:

sales_id	date
======================
3			1171598195
4			1171799435
5			1171855432

how would I query the time()'s for a month... eg: get all from the database where month = Jan.

any ideas?!

SELECT sales_id FROM table_name WHERE FROM_UNIXTIME(date, '%b') = 'Jan'

cool thanks!! what's the $b for?

The %b formats the date a certain way. You can read more about FROM_UNIXTIME() as well as the other date and time functions in MySQL's manual.

super!! thank you very much for your help 🙂