Work with date in C #

Question

Whether the right approach, or you can do the job with the date easier. In particular, it is necessary to select a sample of fields from the database, the date of which is between the beginning and the end of the current day, that is, from 00:00:00 to 00:00:00 of the new day. Since it is planned to use in different time zones, I use UTC.

This is how I declare the sampling range

var startOfDay = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.Day, 0, 0, 0); var endOfDay = new DateTime(DateTime.UtcNow.Year, DateTime.UtcNow.Month, DateTime.UtcNow.AddDays(1).Day, 0, 0, 0);

Then, I make a query to the database, where I check whether the date of the record belongs to the specified range. In the database, the date is stored in UTC format.

It is probably easier to write to the store (with all the logic) and just pull it from C #.

Qwertiy ♦ Qwertiy 76k 17 73 199 · Accepted Answer · 2017-02-14T08:27:05

No, wrong.

The date may change between appeals to DateTime.UtcNow , so you may get an incorrect date (with an error of a day, month, or year).

Still easier:

 var startOfDay = DateTime.UtcNow.Date; var endOfDay = startOfDay.AddDays(1);

Answer 2 · 2017-02-14T08:26:17

First, this code does not work correctly on the last day of the month: you change the day, but not the month.

Secondly, it can be easier:

 var startOfDay = DateTime.UtcNow.Date; var endOfDay = startOfDay.AddDays(1);

Oh, we almost equally answered, only you found another bug :)

Work with date in C #

2 answers 2

More articles: