format result of dat calc in linq

Posted by d daly on Stack Overflow See other posts from Stack Overflow or by d daly
Published on 2010-03-24T17:41:13Z Indexed on 2010/03/24 17:43 UTC
Read the original article Hit count: 279

Filed under:

dateformat

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 posts about dateformat

DateFormat conversion problem in java?

as seen on Stack Overflow - Search for 'Stack Overflow'
my input String is : 2010-03-24T17:28:50.000Z output pattern is like: DateFormat formatter1 = new SimpleDateFormat("EEE. MMM. d. yyyy"); i convert this like this: formatter1.format(new Date("2010-03-24T17:28:50.000Z"));//illegalArgumentException here the string "2010-03-24T17:28:50.000Z" ouput… >>> More
Adroid's DateFormat replacement - missing the format() with FieldPosition

as seen on Stack Overflow - Search for 'Stack Overflow'
Hi, I need to split a date string into pieces and I'm doing it using the public final StringBuffer format (Object object, StringBuffer buffer, FieldPosition field) from the java.text.DateFormat class. However, the implementation of this function is really slow, hence Android has an own implementation… >>> More
SimpleDateFormat give inconsistent results

as seen on Stack Overflow - Search for 'Stack Overflow'
I am trying to parse a date and I am getting different results when I run the code locally/BST compare to a server in Paris/CEST. I've reproduced the issue in a the following sample. This is trying to parse the start date for the Australian Grand Prix. TimeZone tz = TimeZone.getTimeZone("AET"); … >>> More
Receives System.Byte[] in GridView when MySql's DateFormat Function is used

as seen on Stack Overflow - Search for 'Stack Overflow'
I have written this query for retrieving data from mysql as below select FeedbackCode,EMailID,FeedbackDetail, Date_Format(FeedbackDate,'%m,%d') as 'Feedback_Date' from FeedbackDetail where EMailID not like '' and InstanceCode =5 and I'm binding this data with GridView in asp.net but at the… >>> More
Javascript DateFormat for different timezones

as seen on Stack Overflow - Search for 'Stack Overflow'
I'm a Java developer and I'm used to the SimpleDateFormat class that allows me to format any date to any format by settings a timezone. Date date = new Date(); SimpleDateFormat sdf = new SimpleDateFormat("dd-MM-yyyy hh:mm:ss"); sdf.setTimeZone(TimeZone.getTimeZone("America/Los_Angeles")); System… >>> More

Developer IT

format result of dat calc in linq - Developer IT

format result of dat calc in linq

dateformat

Related posts about dateformat

DateFormat conversion problem in java?

Adroid's DateFormat replacement - missing the format() with FieldPosition

SimpleDateFormat give inconsistent results

Receives System.Byte[] in GridView when MySql's DateFormat Function is used

Javascript DateFormat for different timezones

Categories cloud