month of a unix-timestamp

[Anon]

hello, in a mysql-db I have set a column to hold the timestamp ( time(), int(11) ). what i want to do is getting all entries of the current month... i tried with WHERE MONTH(date)=$month, but this won't work...

any ideas? thx

[[deleted]]

What kind of timestamp are you storing in the int(11)? and why don't you just use MySQL's timestamps, which do work with month() etc? 🙂

[Anon]

i'm storing the number which is produced when calling up the time() function... if heard, that it isn't possible to get out the month of this integer? if that's the case, i maybe have to make it to a date field (yyyy-mm-dd)

any ideas? thx

[[deleted]]

You should be able to get around that if you enclose the 'int(11)' field in
FROM_UNIXTIME(), like this:

SELECT MONTH(FROM_UNIXTIME(int_field)) FROM table WHERE foo=bar.

Check out the MySQL manual, there are a number of very usefull functions for working with dates and times of different formats.