CODEWITHSUNDEEP
c#asp.net
Prabhudatta Sahoo
Prabhudatta Sahoo

Reputation: 1

C# datetime format change

I want to convert datetime.now format which is "dd/mm/yyyy hh:mm:ss AM/PM" to US time format i.e. "mm-dd-yyyy hh:mm:ss AM/PM". More over i want the converted format as datetime not in string because the same is being stored in the database and the field in the database is in datetime format so it will not take string.Please suggest....

Upvotes: 0

Views: 969

Answers (3)

Peru
Peru

Reputation: 2971

DateTime usDateTimeFormat = DateTime.Parse(DateTime.Now , 
System.Globalization.CultureInfo.GetCultureInfo("en-us"));

Upvotes: 0

Hary
Hary

Reputation: 5838

Try this. Standard Date and Time Format Strings

DateTime.Now.ToString("g",CultureInfo.CreateSpecificCulture("en-us"))

Upvotes: 0

Jon Skeet
Jon Skeet

Reputation: 1504122

A DateTime value doesn't have a format. DateTime.Now doesn't have a format, and if you do any kind of conversion, if you've got a DateTime, there's no format. The concept of a format only applies when you're converting to or from a string - and DateTime.Now is a DateTime, not a string.

Just insert the value into the database using DateTime.Now (or DateTime.UtcNow) and you'll preserve the data which is the important part.

You should only perform string conversions when you actually have to - at which point you can use DateTime.TryParseExact and DateTime.ToString using custom date/time format strings. (Use TryParseExact for user input; for machine input which really should be valid, use DateTime.ParseExact.)

Note that it's usually a good idea to use custom date/time patterns with the invariant culture, or standard date/time patterns with "real" cultures (e.g. the user's culture).

Upvotes: 6

Related Questions