Conversion failed when converting date and/or time from a character string

Question

This code was working yesterday but not now. I haven't changed anything... Why is that and how can i fix it?

    {
        var info = TimeZoneInfo.FindSystemTimeZoneById("Turkey Standard Time");
        DateTimeOffset localServerTime = DateTimeOffset.Now;
        DateTimeOffset istanbulTime = TimeZoneInfo.ConvertTime(localServerTime, info);

        con.Open();
        cmd.CommandText = "UPDATE BilgisayarDuyuru SET date='" + istanbulTime + "'  WHERE id='" + id + "'";
        cmd.ExecuteNonQuery();
        con.Close();            
    }

you'll probably have to clarify your question along with adding a few examples of things you tried in order to receive any help. You can always update your question. Welcome to stack overflow, recommended reading: stackoverflow.com/help/how-to-ask — Dan Beaulieu
– Dan Beaulieu, Commented May 13, 2015 at 1:41
No i didn't change anything. But now it's working. Still not changed anything. Should i delete this question ? — CePur
– CePur, Commented May 13, 2015 at 1:49
Not working now means..r u getting any error..please more specific.. — Sachu
– Sachu, Commented May 13, 2015 at 3:09
@Sachu Now it's not working again. Not working means it gives the error which in the title :) — CePur
– CePur, Commented May 13, 2015 at 3:22

Sachu · Accepted Answer · 2015-05-13 04:13:14Z

4

Ok try this

{
 var info = TimeZoneInfo.FindSystemTimeZoneById("Turkey Standard Time");
 DateTimeOffset localServerTime = DateTimeOffset.Now;
 DateTimeOffset istanbulTime = TimeZoneInfo.ConvertTime(localServerTime, info);
string s1 = istanbulTime.ToString("yyyy-MM-dd HH:mm:ss.ffffff zzz");
con.Open();
cmd.CommandText = "UPDATE BilgisayarDuyuru SET date='" + s1+ "'  WHERE id='" + id + "'";
cmd.ExecuteNonQuery();
  con.Close();            
}

answered May 13, 2015 at 4:13

Sachu

7,7549 gold badges59 silver badges101 bronze badges

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

Comments

JohnS · Accepted Answer · 2015-05-13 03:59:27Z

0

Yesterday was the 12th today is the 13th. Are you sure that month and day are not being mixed up? After all I'm sure that in Instanbul you only have 12 months?

answered May 13, 2015 at 3:59

JohnS

2,0581 gold badge14 silver badges16 bronze badges

Collectives™ on Stack Overflow

Conversion failed when converting date and/or time from a character string

2 Answers 2

Comments

Comments

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

2 Answers 2

Comments

Comments

Your Answer

Sign up or log in

Post as a guest

Related