How to insert this datetime value to DB using EF 31/12/2021 11:59:59 PM (end of the day in the year)

Question

0.00/5 (No votes)

See more:

how to insert this datetime value to DB using EF 31/12/2021 11:59:59 PM (end of the day in the year)

1- i created this field fiscal_year_end and its datatype is DATETIME.
2- now i trying to update the record with the value fiscal_year_end

C#

var DB1 = ConnectionTools.OpenConn();
var SS = DB1.ad_system_settinges.Find(1);
SS.fiscal_year = NewYear;
SS.fiscal_year_start = NewYear_start;
SS.fiscal_year_end = NewYear_end;
DB1.SaveChanges();

where this variable NewYear_end have this value 31/12/2021 11:59:59 PM
but whene i checked the inserted value (using my project interface also also using workbench) i fount that this field fiscal_year_end have this value 2022-01-01 00:00:00 Which means it was rounded to the next day automatically (1 second was added).

What I have tried:

i putted break point after this line

C#

SS.fiscal_year_end = NewYear_end;

and i fount that have this value 31/12/2021 11:59:59 PM

Posted 9-May-20 10:59am

Golden Basim

Updated 9-May-20 11:35am

v3

Add a Solution

Comments

MadMyche 9-May-20 17:17pm

Which value is that; ss.fiscal_year_end or NewYear_end?
What happens if you step to the next line; is the value the same?

Golden Basim 9-May-20 17:35pm

i putted break point after this line

 SS.fiscal_year_end = NewYear_end;

and i fount that the both ss.fiscal_year_end or NewYear_end have this value 31/12/2021 11:59:59 PM

Richard MacCutchan 10-May-20 4:02am

Why do you need both times? If you just set year start to the first day at 00:00:00, it is a simple matter to calculate the end date.

Golden Basim 11-May-20 11:21am

Yes, your words are logical, I will actually do it, but I would also like to know the reason why the value is inserted wrongly in databases

Richard MacCutchan 11-May-20 12:04pm

We cannot tell you why it is wrong as we have no access to either your code or your data. You need to use your debugger to see exactly what happens when you run the above code.

Member 13541763 11-May-20 5:21am

make it more clear, are you facing exception or unexpected data?

Golden Basim 11-May-20 11:19am

no , this code just insert wrong value

Maciej Los 14-May-20 2:41am

Are you really sure that NewYear_end variable is storing 31/12/2021 11:59:59 PM value?
Can you show us how you initiate that variable (declaration and initiation)?

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)