[Resolved] SQL question Current Month

[Arc]

Hi all. I need some help with an SQL statement that will get only the records that were added in the current month. Not in the last 30 days. If it's OCT, for instance, then I only want to get the records that were added in OCT.

I am using MySQL and the date is formated as yyyy-mm-dd.

SOmething like this

$SQL="SELECT * FROM tblLogs WHERE DateAdded=ThisMonth";

Any ideas are appreciated.

Thanks!😃

[LordShryku]

Check here

Look up date_format

[Arc]

Thanks, I figured it out.