It changes minutes and seconds to I want to put them unchanged. Show 1 more comment. Pradeep Rajput Pradeep Rajput 6 6 silver badges 11 11 bronze badges. Sign up or log in Sign up using Google. Sign up using Facebook. Sign up using Email and Password. Post as a guest Name. Email Required, but never shown. The Overflow Blog. Podcast Helping communities build their own LTE networks. Podcast Making Agile work for data science. Featured on Meta. New post summary designs on greatest hits now, everywhere else eventually.
Visit chat. Linked Robotnik 3, 2 2 gold badges 29 29 silver badges 46 46 bronze badges. Serkan Hekimoglu Serkan Hekimoglu 4, 5 5 gold badges 36 36 silver badges 62 62 bronze badges.
This worked, but I tried it before without all zeros and it did not work. I tried it with ' Nice, seriously dont have any idea. Because you wrote without time information, and SQL must attach default So it must be worked. If it says 'One record changed' then perhaps you need to show us how you verify Remus Rusanu Remus Rusanu k 39 39 gold badges silver badges bronze badges.
The date format is why I was thinking being explicit about the conversion would be a good idea This worked for me and saved me a few steps because the field I'm converting was already using this format, i. Aaron Bertrand k 36 36 gold badges silver badges bronze badges. Moe Sisko Moe Sisko Evgeny Sobolev Evgeny Sobolev 4 4 silver badges 13 13 bronze badges.
That should work, I'd put brackets around [Date] as it's a reserved keyword. OriginalOcto OriginalOcto 21 1 1 bronze badge. Is there maybe a trigger on the table setting it back? Gratzy Gratzy 8, 4 4 gold badges 27 27 silver badges 44 44 bronze badges. What I really need is to change a March 12, to March 7, But I don't want to change the time. Erland Sommarskog. Thanks, that did the trick.
This discussion thread is closed Start new discussion. Similar topics PHP. MySQL Database. Bader last post: by. Datetime field in SQLserver database empty? Visual Basic.
0コメント