TIMESTAMP column type

I have a table where it has a TIMESTAMP column datatype…
And here is the problem:

I want to do some calculations regarding the dates which is in this format:yyyy/mm/dd…
The issue is though that the dates coming from the client to the server(so as to perform the various calculations)is in this format and it is the format used by HTML5 input date type:mm/dd/yyyy

How do you propose I deal with this discrepancy?
Various things come into my mind…I just want you to hear what YOU have to say.

use the STR_TO_DATE function

no function will be needed after all…thanks for the help.

This topic was automatically closed 91 days after the last reply. New replies are no longer allowed.