displaying date format

[hurrem]

Hi, I'm getting date from SQL table, where it is saved as 7/31/2007 12:00:00 AM I need to show this date as July, 31 2007 without the time. is there any easy way to do that? thanks

[Michael P Scherer]

Usually its safest to use the ISO date standard, so yyyy-MM-dd. In your case, that would be 2007-31-07 and I'm pretty sure the 7 has to be preceded by a 0 for it to work properly, let alone for any single-digit number in the date.

www.socoder.net

[hurrem]

Thanks for reply, but I didn't get you. I'm getting the date as it is and I need to display it on a label in a readable format, i.g., as Oct, 27 2007

[Sun Rays]

Hi, you can check here[^]

Thanks, Sun Rays To get something you must have to try once. My Articles

[bhanu12345]

hi try this code string a a = your date from sqlserver label.text = DateTime.Parse(a).ToLongDateString(); and let me know Bhanu

[Sathesh Sakthivel]

yourDate.ToShortDateString() use this . Hope this will also help you.

SSK. Anyone who says sunshine brings happiness has never danced in the rain.