I am trying to select all the entries that occured in the current month.
Up to now, i have only figured out how to get all entrie for the current day by doing this
Code: Select all
select * from pis where pi_date = date_format(NOW(), '%Y-%m-%d')Thanks
Mark