DateTime Conversion Error.

Abdul Amin Khan

Dear All,

Anyone please tell how to change format of Date to "dd/MM/yyyy hh:mm:ss" from "MM/dd/yyyy hh:mm:ss".

Here is an issue:

//================

var GetLastDBBackupTime = string.Empty;

GetLastDBBackupTime = Convert.ToDateTime("12/15/2017 15:30:25").ToString("dd/MM/yyyy hh:mm:ss");//Showing error Inputed string was not in Correct format.

Output will be : 15/12/2017 15:30:25

if (Convert.ToDateTime(DateTime.Now.ToString("dd/MM/yyyy hh:mm:ss")).TimeOfDay > Convert.ToDateTime(GetLastDBBackupTime).AddHours(1).TimeOfDay)

CreateBackup();

Please help.

its Urgent

7 Replies

Know the answer? Post it — somebody with the same question will find it here.

Pranay Rana8y ago
Working code, its just capital HH
DateTime dt = DateTime.ParseExact("12/15/2017 15:30:25", "MM/dd/yyyy HH:mm:ss", CultureInfo.InvariantCulture);
dt.ToString("dd/MM/yyyy hh:mm:ss");
I suggest dont depend on your computer in case of your application is going to run in different time zone and different areas of world have different format, it good to parse string and store in the formate your database want
Amit Gupta8y ago
Hey Abdul

As you know, computer understands a set of instructions, it process the instructions and gives you the output based on the appropriate instructions.

However, if you take an example date like 5/8/2017 then how can you determine that the date is 5th of Aug or it is 8th of May?

Hence, you have to take care before parsing this.

Good Luck
Shweta Lodha8y ago
Hi, even I have the same opinion as Amit Gupta. In this case, you can go for UTC.
Abdul Amin Khan8y ago
Pranay Sir,

Already tried got same error.
Abdul Amin Khan8y ago
Amit Gupta Sir, I know the same i want a global conversion technique that will ignore any date format of local system
Pranay Rana8y ago
you have to make use of DateTime.ParseExact to convert you string value to datetime vlaue. and then convert your datetime value back to string using ToString()
DateTime dt=DateTime.ParseExact("12/15/2017 15:30:25", "MM/dd/yyyy hh:mm:ss", CultureInfo.InvariantCulture);
dt.ToString("dd/MM/yyyy hh:mm:ss")
Amit Gupta8y ago
Hey

The error occurred because of your date format, your pc might have a format of dd/MM/yyyy, thats why when you have pass 12/15/2017 it throws exception.

The computer doesnot have 15 as a month. Be conscious before passing the date.

Rather than, your code is ok