Date Time Format problem between MariaDB and C#

Asked Jan 24 '20 at 12:56

Active Jan 24 '20 at 13:02

Viewed 186 times

I am trying to retrieve some data from MariaDB database to a datagridview in a C# form application. If I am adding a date condition in the query string, it seems like not returning anything. Is it the problem with the date format? Or is it the problem with my query string? Thank you

// selected date is chosen through date time picker
// format is 24/01/2020 10:10:10
selectedDate = dateTimePicker1.Value; 
string query = "SELECT Voltage, Current FROM data_table WHERE device_id='" + Device_ID + "' AND data_date >'"+ selectedDate +"'";

//MariaDB date format is 2020-01-24 09:09:09

asked Jan 24 '20 at 12:56

master_yoda

2

Never use string concatenation. It opens all kind of SQL injection attacks – Thomas Weller Jan 24 '20 at 13:02
1

Try a parameterized query instead. https://stackoverflow.com/questions/652978/parameterized-query-for-mysql-with-c-sharp – Thomas Weller Jan 24 '20 at 13:02
Does this answer your question? [DateTime formatting in .Net for MySQL database](https://stackoverflow.com/questions/2010548/datetime-formatting-in-net-for-mysql-database) – Thomas Weller Jan 24 '20 at 13:04
Show us the query after it as been constructed. – Rick James Jan 30 '20 at 15:52

Date Time Format problem between MariaDB and C#

0 Answers0