Valid date not converting to datetime2

Asked Mar 22 '18 at 14:33

Active Mar 22 '18 at 14:40

Viewed 86 times

I have a simple table with 2 date time fields

These are setup within my objects with valid dates

However, when saving the values are getting generated by entity framework as 0001-01-01 00:00:00

What can cause this?

I am using Entity Framework Core against SQL Server 2016

Please see the image below which proves I have valid dates

I have noticed that the date is shown in USA format not sure if thats an issue?

I am not using an edmx, I have tried [Column(TypeName = "datetime2")] above the columns as well as trying with the column being both nullable and not nullable

My insert code is below

    using (var db = new MydbContext(connectionsString))
    {
        var rawItem = db.tblItem.FirstOrDefault(x => x.ItemId== createItem.Item.ItemId);
        if (rawItem == null)
        {
            rawItem = new tblItem();
            db.tblItem.Add(rawItem);
        }

        rawItem.ItemdDateTime = message.Item.ItemDateTime;
        rawItem.ProcessedDateTime = message.Item.ProcessedDateTime;

        await db.SaveChangesAsync();
    }

Paul

edited Mar 22 '18 at 14:40

asked Mar 22 '18 at 14:33

Paul

2,773
7
41
96

It’s a date time column – Paul Mar 22 '18 at 14:36
1

can you post your C# call to insert – Ryan Wilson Mar 22 '18 at 14:36
Have added it above – Paul Mar 22 '18 at 14:40
See this question: https://stackoverflow.com/questions/1331779/conversion-of-a-datetime2-data-type-to-a-datetime-data-type-results-out-of-range – dont_trust_me Mar 22 '18 at 15:06
Ok there are loads of comments on this and most are very old I will take a look when I get back to the office. The strange thing is that my variable has a valid date? So I don’t understand how that can get mapped to no date which then causes this – Paul Mar 22 '18 at 16:55

Valid date not converting to datetime2

0 Answers0