Casting Varchar to a date

[Bradley Kjeldsen]

Hi there,

I am using MYSQL & PHPAdmin

I have a column called dispatchdate which is being stores as VARCHAR(255).
It is storing dates though as '12/06/2013' format. (DD/MM/YYYY)

I want to be able to in my PHP to display only the dates for the current month.

Can anyone please help with this?

I am assuming I need to use a CAST function, but i've tried different formats and MYSQL gives me an error.

Would appreciate any help.
Thanks.