Скачать или смотреть How to Remove Date from DateTime in LINQ C#

Learn how to extract only the time from a DateTime variable in LINQ queries, and find the minimum time efficiently.
---
This video is based on the question https://stackoverflow.com/q/62279596/ asked by the user 'jitender singh' ( https://stackoverflow.com/u/8189433/ ) and on the answer https://stackoverflow.com/a/62279799/ provided by the user 'Tomas Chabada' ( https://stackoverflow.com/u/1427786/ ) at 'Stack Overflow' website. Thanks to these great users and Stackexchange community for their contributions.

Visit these links for original content and any more details, such as alternate solutions, latest updates/developments on topic, comments, revision history etc. For example, the original title of the Question was: how to remove date from datetime in Linq c#

Also, Content (except music) licensed under CC BY-SA https://meta.stackexchange.com/help/l...
The original Question post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license, and the original Answer post is licensed under the 'CC BY-SA 4.0' ( https://creativecommons.org/licenses/... ) license.

If anything seems off to you, please feel free to write me at vlogize [AT] gmail [DOT] com.
---
How to Remove Date from DateTime in LINQ C#

When working with DateTime values in C# LINQ queries, you may encounter situations where you need to focus on the time component of these values, ignoring the date part entirely. This can be particularly useful when you want to determine the minimum time from a collection of DateTime objects, regardless of their associated dates.

In this guide, we will explore an effective method to remove the date part when working with a list of DateTime values and show you how to extract only the time, leading to the desired output.

Understanding the Problem

Given an array of DateTime values, for instance:
["02/12/1970 14:52:06", "14/06/2015 12:32:44"],

you might want to find the minimum time. However, if you directly use LINQ's Min() method on these DateTime values, the output would be based on the entire DateTime, leading to potentially misleading results. For the above example, without correctly focusing on the time, you might get "14:52:06" instead of the expected "12:32:44".

Solution: Extracting Time from DateTime

The best approach to solving our problem involves two straightforward steps:

Extract the Time Component

Find the Minimum Time

Here’s how you can achieve this in code:

Step 1: Extract the Time Component

First, we need to create a list of DateTime instances:

[[See Video to Reveal this Text or Code Snippet]]

Step 2: Find the Minimum Time

Next, we can use the Select() method to project each DateTime to its TimeOfDay, and then apply Min() to find the minimum among them:

[[See Video to Reveal this Text or Code Snippet]]

Full Implementation

Here is the complete code to carry out the above steps:

[[See Video to Reveal this Text or Code Snippet]]

Bonus: DateTime Object with Minimum Time

If your requirement shifts toward obtaining the full DateTime object with the smallest time part while still ignoring the date, you can do this with the OrderBy() method:

[[See Video to Reveal this Text or Code Snippet]]

Conclusion

By focusing on using the TimeOfDay property of DateTime, we are able to filter out just the time values, allowing us to effectively find the minimum time without being influenced by the date. This approach can be crucial when dealing with datasets where only the time aspect is relevant.

You are now equipped with a reliable method to extract only the time from DateTime variables in your LINQ queries. Happy coding!