Tuesday, June 14, 2016

Converting Date Format and Time

 var for_formatting = (from n in db.BillMasterDbSet where n.COMPID == compid && n.PATIENTYY == year && n.PATIENTYYID == yearID select n).ToList(); //fetch data

                    string billdt= "", discharge = "", disTime = "";
                    foreach(var x in for_formatting)
                    {
                        billdt = Convert.ToDateTime(x.BILLDT).ToString("dd-MMM-yyyy");
// Example: Jun-14-2016
                        discharge = Convert.ToDateTime(x.DISCHGDT).ToString("dd-MMM-yyyy");
                        disTime = Convert.ToDateTime(x.DISCHGTM).ToString("HH:mm:ss");

                    }

No comments:

Post a Comment