,how to show 24 hours time format ?

[absprogrammer]

hi I'm using SQL server7.0 and asp.net. i'm store use datatype 'datetime' to store date in database. when i retrve data from database i want to show time in 24 hour format insted of 'am/pm' eg. '1:02:00 pm' ====> '13:00:00' thanks in advance.

[Guffa]

Provide the correct CultureInfo when you convert the date to a string. Example: string myString = myDateTime.ToString("T", new CultureInfo(sv-SE")); --- b { font-weight: normal; }

[MihirV]

hi there, you can convert the database DateTime type to string in your front-end code like follows string sDate = dbDate.ToString( "dd/MM/yyyy HH:mm" ); will returns time in 24 hours format :) Confidence comes not from always being right, but from not fearing to be wrong..... Mihir..

[absprogrammer]

thanx