I am following the document from here:
This one gave me the result: >
Between
WHERE (DATE_FORMAT) ('2014 03' and '2014 06') but this is not: <<> < Code> I want to use this type of date:
WHERE (between DATE_FORMAT 'March 2014' and 'June 2014') Code> April 2014
What did I do? Thanks in advance for any input.
You can not compare stars. The comparison you are looking for is alphabet, so there is nothing because "march"> "june".
The comparison of two stings is more than M
alphabetically to J
and therefore 2014 is more than 2014 June.
Do not try to use wire for comparative factors
Comments
Post a Comment