tags:

views:

5

answers:

0
Q: 

format result of dat calc in linq

Hi

I have a calculation in a linq query, although it brings back the correct nuber of days, Im not sure how to better format it

select new { time = (System.DateTime.Today - cs.date_case_opened), }; just now it shows eg 4:00:00:00 if the difference is 4 days, any ideas how i can present this better?

thanks

related questions

flex3 Format date without timezone
Get date format like "Y-m-d H:i:s" from a php date
Convert to dd/mmm/yyyy
Can I alter DateFormat.SHORT to include seconds or something similar?
Silverlight Date Formats
Formatting time on Android, while following preferences (24 hr clock vs. AM/PM, etc..)
Localized date and numberformats in GWT
how to change default dateformat AAAA-MM-DD to dd/mm/yyyy in Django?
ASP.NET MVC - XVal clientside validation of dates
Parsing a date with short month without dot
Date as simple text (e.g. Today, Yesterday, 1 Week Ago) in .Net
Manipulating dates in Javascript without the Date object
Javascript formatting date strangely
Human readable and parsable date format in Java.
Java Date Format that allows - / or . as separators within date
How to display a date as ISO8601 with JSTL?
Working with dates in asp.net
Parsing standard date to GMT
Getting mySQL date_format to display in PHP
where does asp and iis 6.0 get its date format
Displaying a date with a custom timezone.
What date format is "ds1248083197360"?
Date format problem using SSIS for Excel into SQL Server
Java date format to JavaScript date format
Crystal Reports 2008: C#: Edit Date format on the fly