Is the field defined as a date value or a string? Most databases have an internal date data type, and I doubt that they will automatically convert strings to it. Most have a function to do so, though. I believe for MySQL it's STR_TO_DATE. I want to say that others use AS_DATE.