How to convert date time in standard format

I get date in proper format from the database but i get time in improper format i.e 19/10/2010 4:45:00 AM开发者_StackOverflow社区 . I want my time to be hh:mm:ss. I am getting only single hour i.e h. Appending 0 doesnt seem to be a good solution what is an alernative to parse it in expected format i.e hh:mm:ss?

Did you try:

yourDate.ToString("dd-MM-yyyy HH:mm:ss");

The uppercase "HH" indicates the 24-hour formatting...

Use dateTime.ToString("g");//g - general datetime format.
Custom Date and Time Format Strings

or use some custom format: dateTime.ToString("dd/MM/yyyy HH:mm:ss");
Standard Date and Time Format Strings

Pass the right format to the DateTime.ToString Method as the following:

dateValue.ToString("dd/MM/yyyy hh:mm:ss tt");

If you are using Sql Server then use

Convert(getdate(),varchar(15),109)

Details can be found here SQL Server Date Time Format

I'm not sure what your problem is. How are you getting a date with improper format from the database? Are you receiving an already formatted string?

If so, then you can parse it into a valid DateTime using the following:

DateTime d = 
    DateTime.ParseExact(date, "dd/MM/yyyy h:mm:ss tt",CultureInfo.InvariantCulture);

If you already have a DateTime then you can format it to a string with any of the methods already proposed in the other answers.

There is nothing "improper" about the date format you are receiving, that is simply the default format for your database (which I believe can be changed by your dba if appropriate)

You want to change the rendered format. You can do this using DateTime.ToString(string Format)

 DateTime dt = DateTime.Parse("19/10/2010 4:45:00 AM");
 dt.ToString("hh:mm:ss");

Parsing is how the DateTime object reads the existing format to set it's value, ToString is about rendering it out.

yourDate.ToString("dd-MM-yyyy HH:mm:ss");

USE THIS IT WILL WORK.