This question is locked. New answers and comments are not allowed.
Ahmed Ilyas
Top achievements
Rank 1
Rank 1
Ahmed Ilyas
asked on 12 Oct 2011, 02:25 PM
if my grid shows something like this for a date/time column:
04/10/11 14:53:00
and I am using IQueryable on LINQ->SQL. When I apply a filter on that column, I always get a SQL DateTime overflow error.
What can I do to "fix" it to the correct format, so the LINQ->SQL query is correct when filtering on a datetime column?
The original value does come from SQL, and is them placed into a flattened model (public DateTime CreatedAt {get;set;})
04/10/11 14:53:00
and I am using IQueryable on LINQ->SQL. When I apply a filter on that column, I always get a SQL DateTime overflow error.
What can I do to "fix" it to the correct format, so the LINQ->SQL query is correct when filtering on a datetime column?
The original value does come from SQL, and is them placed into a flattened model (public DateTime CreatedAt {get;set;})
1 Answer, 1 is accepted
0
Hello Ahmed Ilyas,
Rosen
the Telerik team
The date you have pasted seems ok. Could you please send us the generated SQL for this query?
Regards,Rosen
the Telerik team
If you want to get updates on new releases, tips and tricks and sneak peeks at our product labs directly from the developers working on the Telerik Extensions for ASP.MET MVC, subscribe to their blog feed now