How can i change Date format in C# (DatePicker)?

Question

I created a format with a date. It's XML code is very easy:

<DatePicker x:Name="data" Grid.Row="4" TextColor="Silver" MinimumDate="12/12/1900"/>

But I need to save this date in SQL, but the format is wrong. The format of SQL is yyy-mm-gg while the format of datepicker is mm-gg-yyyy.

How can i change this? thanks a lot

A date is a date regardless of how you format it in the UI. Store it as a `DATE` in the database and you're all set. — mm8, Apr 09 '20 at 09:50
@mm8 I did, but it gives me the error because they are formed by DATA of sql and datepicker are different — Alessia, Apr 09 '20 at 09:56
Then you are inserting the value into the database the wrong way. — mm8, Apr 09 '20 at 09:57
int result = db.QueryInserimento("INSERT INTO thewishlist.user(data) VALUES(''"+data.Date+"')"); — Alessia, Apr 09 '20 at 09:59

mm8 · Accepted Answer · 2020-04-09T11:53:09.200

A date is always a date regardless of how you format it in the UI.

You should store the value as a DATE in the database and retrieve it from the DatePicker using the Date property. It returns a DateTime that you should insert into the database using a parameter.

Please read the following regarding how and why to use parameters in your SQL statements:

How can I add user-supplied input to an SQL statement?

You may format a DateTime programmatically using the ToString method overload that accepts a format string:

data.Date.ToString("yyyy-MM-dd")

How can i change Date format in C# (DatePicker)?

1 Answers1