MySQL DateTime Format with c# failing

Question

HI I am writing a sample application to insert and retrive datetime format . The Insert i did was sucessfull but dont know why it fails when i query to retrieve it . .

My insert goes like this..

string SqlQuery = "INSERT into BenchMarking Values (" + i + " , 'XXXX','This is a testing','M','2010-05-05 05:06:01')";
        sqlWrapper.ExecuteNonQuery(SqlQuery);

but when i query them its not returning me anything ...

retrive query

   string sqlQuery = "select Id from BenchMarking where Datetime = '2010-05-05'";
reader = sqlWrapper.ExecuteQuery(sqlQuery);

anyone knows why this is happening?

Pekka · Accepted Answer · 2010-10-25 22:31:31Z

2

If you specify 2010-05-05 as a DATETIME value, it will default to 2010-05-05 00:00:00 which is different from the record you inserted.

What you are probably looking for is DATE() which extracts the date part from a DATETIME value.

select Id from BenchMarking where DATE(Datetime) = '2010-05-05'

answered Oct 25, 2010 at 22:31

Pekka

451k150 gold badges989 silver badges1.1k bronze badges

Sign up to request clarification or add additional context in comments.

Comments

a1ex07 · Accepted Answer · 2010-10-25 22:32:28Z

0

You probably need to change your query to select Id from BenchMarking where Date(Datetime_column_name) = '2010-05-05'

answered Oct 25, 2010 at 22:32

a1ex07

37.4k12 gold badges93 silver badges103 bronze badges

Comments

william · Accepted Answer · 2010-10-26 06:19:34Z

0

"select Id from BenchMarking where (CONVERT(VARCHAR(10), ArrivalTime, 111) = '2010/05/05')"

you need to format the date to varchar.. for formatting, u can use this..

http://www.sql-server-helper.com/tips/date-formats.aspx

answered Oct 26, 2010 at 6:19

william

7,79419 gold badges72 silver badges107 bronze badges

Collectives™ on Stack Overflow

MySQL DateTime Format with c# failing

3 Answers 3

Comments

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

3 Answers 3

Comments

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related