how to select current month

[vin_akleh]

how can i do this?

select * From table_name Where date = currentmonth

when date is a double and i insert it like so date = date("U")

so i want to select the month of date("U") for the current month

[Pikachu2000]

Although I'd really recommend storing dates and times in YYYY-MM-DD HH:MM:SS format in s a DATETIME field, this should do what you're asking:

 

SELECT field FROM table WHERE MONTH(FROM_UNIXTIME(date)) = MONTH(CURDATE())