DateTime values is getting incorrect from XML to Database

Rupesh Kahane

7y1k

I have model with some properties and I am passing xml file to my store procedure.

below is the property in my model

While passing LastUpdatedDateTime values from C#, I am passing current date time

In xml I am getting format like below

Now database value is not inserting as per curent datetime

Can anyone please correct it. What exactly I am missing into this???

3 Replies

Know the answer? Post it — somebody with the same question will find it here.

Amit Mohanty7y ago
Hey try this
public string LastUpdatedDateTime{get;set;}

LastUpdatedDateTime = DateTime.Now.ToString("yyyy-MM-dd HH:mm:ss");
then pass to xml file.
Rajanikant Hawaldar7y ago
do this, example

public class SomeClass
{
[XmlIgnore]
public DateTime SomeDate { get; set; }
[XmlElement("SomeDate")]
public string SomeDateString
{
get { return this.SomeDate.ToString("yyyy-MM-dd HH:mm:ss"); }
set { this.SomeDate = DateTime.Parse(value); }
}
}
Bidyasagar Mishra7y ago
convert that datetime format to any databse needed format then send it