Q: MySQL only accept yyyy/mm/dd? : I am new into developer world, i hope you guys can guide me well. From what i know MySQL will only accept datatype date with format `YYYY/MM/DD`. 

If i change `dateformat` into `DD/MM/YYYY` in my web application and click save, there will be an error occur and no data was record (500-Internal Server error).

So, how to make a user input `DD/MM/YYYY` and MySQL will accept the `DD/MM/YYYY` and the data will record

    <cfquery name="testrecorddate" datasource="myData">
    INSERT INTO DATE_DATE 
    VALUES 
    ('#Form.RecordDate#')

    <form action="" method="post">
    <textarea name="RecordDate"> 13/03/2018 </textarea>
    <input type="Submit" value="Save"><input type="Reset" value="Clear">
    </form>
    </cfquery>

I am using ColdFusion languange and still learning. Is there possible to dump MySQL by display only on coldfusion dateformat `DD/MM/YYYY` and MySQL can stored the data wihout an error happen. 