I need to get date from datetime in linq like this:
var items = db.Students.ToList().Select(u => new { bi = u.Birthday.Date });
but items in grid are displayed as follows:
How can I fix it?
Thanks.
Asked
Active
Viewed 2,147 times
-2
Ali Soltani
- 9,589
- 5
- 30
- 55
-
1I'm assuming Birthday is a string? What format is it in? You should really be storing Birthday as a DateTime object rather than as a string, it will make your life FAR easier. You can't reliably sort on that field if it is stored as a string for starters. – Gavin Coates Jul 07 '16 at 07:52
-
Why are you trying to generate a string instead of simply returning the date??? If you want to *format* the value for display, do so on your view or form, not your query. If you want to return only the date portion use `.Date` – Panagiotis Kanavos Jul 07 '16 at 07:53
-
What is `Birhday`'s type? – Panagiotis Kanavos Jul 07 '16 at 07:56
-
@GavinCoates Birthday is a datetime. I do not want convert to string. – Ali Soltani Jul 07 '16 at 07:59
-
@PanagiotisKanavos Birthday is a datetime. I edited my question. – Ali Soltani Jul 07 '16 at 08:04
-
@Patrick Hofman this question is not duplicate. I see very answer in stack. They did not solve my problem. – Ali Soltani Jul 07 '16 at 08:21
-
So you got the date, right? What is the problem with the outcome? – Patrick Hofman Jul 07 '16 at 08:38
-
@Patrick Hofman I ask this question in better text see this: http://stackoverflow.com/questions/38241422/get-date-from-datetime-in-linq-and-show-gridview – Ali Soltani Jul 07 '16 at 09:08
1 Answers
4
The Method string.Format can't betranslated into a SQL statement. But you can materialize the rows first .ToList() and string.Format afterwards.
var items = db.Students.ToList().Select(u => new { bi = string.Format("{0:MM/dd/yyyy}", u.Birthday) });
fubo
- 44,811
- 17
- 103
- 137
-
The power of Linq sometimes works against it ;-) It is so powerful you can't imagine there a things it can't do. But when working on non-.NET sources like SqlServer Linq sometimes just can't 'translate' the Linq to a SQl statement. The message "can't translate in a store expression" isn't really clear for that situation. – Michel Jul 07 '16 at 07:56
-
2@Michel what do you mean? The error is *very* clear - you can't use String.Format and that's it. In fact, trying to format strings in SQL is a bad idea in general, even if a `FORMAT` function is available – Panagiotis Kanavos Jul 07 '16 at 07:57
-
-
-
@PanagiotisKanavos: I don't think that when you first encounter this problem (that Linq can't translate your Linq into Sql) that .NET makes a clear hint of that with the message "can't translate in a store expression" – Michel Jul 07 '16 at 09:23