About Date in Mysql

Question

I’m doing a program for a college job, with a database connection.

On a table, I have a column NASCIMENTO of the kind DATE. On the show I have a MaskedTextBox to enter the date of birth, but I put our date medium, DD/MM/YYYY, and in the bank the standard is YYYY/MM/DD, how do I convert it? Because I’m not able to input the data, because of the difference.

It would be better to convert inside the INSERT from the bench or to do for the C#?

Example: I entered the date 12/04/1992, it has to be transformed in 1992/12/04 to be stored in the bank.

Answer 1

The default for Mysql is, AAAA/MM/DD, in this way, the ideal would be for you to convert INSERT of C#, which would give you a higher portability between banks, since this standard is almost for all banks.

Answer 2

Good, you can convert with C#

DateTime dt = DateTime.ParseExact("04/26/2016", "MM/dd/yyyy", CultureInfo.InvariantCulture);

I recommend researching your questions better before asking in the community, not to be negative and help keep the focus of the community on questions not yet resolved.

https://stackoverflow.com/questions/36839196/how-to-convert-dd-mm-yyyy-formatted-string-date-to-yyyy-mm-dd-datetime