In a database table I have made a date attribute, but I have set its type to
varchar and not
Date. My question is: will I still be able to compare such dates in a SQL Query?
Dates in my DB are stored in this format:
I have to do a SQL Query in PHP that looks something like this:
SELECT * FROM DBtable WHERE DBname='$name' AND date>='31/01/2015' AND date<='31/09/2015';
'date' looks like this:
I would appreciate an example of how to do this.