Date time Formats

Question

I need to compare string date=May 16 2010 7:20:12 AM CDT with Current date time . I am getting the below exception when I convert date to datetime. Invalid date time format

Amit Gupta · Answer

Hey DateTime.ParseExtract(..) needs the extact format as you mentioned otherwise it throws exception. Use this one string dts = Thursday May 11 2017 1:09:08 AM CDT ; var dt = DateTime.Parse(dts.Replace( CDT   )).Add( new TimeSpan(05 00 00)); var GMT =dt.ToString( dddd MMM dd yyyy H:mm:ss tt zzz ); CDT stands for Central Daylight Time . GMT is known as Greenwich Mean Time . GMT is 5 hours ahead of CDT. So when it is 12:00 am CDT 1:00 am CDT 2:00 am CDT 3:00 am CDT 4:00 am CDT 5:00 am CDT 6:00 am CDT 7:00 am CDT 8:00 am CDT 9:00 am CDT 10:00 am CDT 11:00 am CDT 12:00 pm CDT 1:00 pm CDT 2:00 pm CDT 3:00 pm CDT 4:00 pm CDT 5:00 pm CDT 6:00 pm CDT 7:00 pm CDT 8:00 pm CDT 9:00 pm CDT 10:00 pm CDT 11:00 pm CDT it will be 5:00 am GMT 6:00 am GMT 7:00 am GMT 8:00 am GMT 9:00 am GMT 10:00 am GMT 11:00 am GMT 12:00 pm GMT 1:00 pm GMT 2:00 pm GMT 3:00 pm GMT 4:00 pm GMT 5:00 pm GMT 6:00 pm GMT 7:00 pm GMT 8:00 pm GMT 9:00 pm GMT 10:00 pm GMT 11:00 pm GMT 12:00 am GMT 1:00 am GMT 2:00 am GMT 3:00 am GMT 4:00 am GMT You can get the difference in the below link https://www.worldtimebuddy.com/cdt-to-gmt-converter

Mayank · Answer

I am getting the exception in below code: string dts = Thursday May 11 2017 1:09:08 PM CDT; DateTime dt = DateTime.ParseExact(dts.Replace(CDT -05:00) MMM dd yyyy H:mm:ss tt zzz null); Please correct my code.

Khaja Moizuddin · Answer

You were supposed to use date in date time data type instead of string.

Amit Gupta · Answer

Hey Central Daylight Time (CDT) is 5 hours behind Coordinated Universal Time (UTC). This time zone is a Daylight Saving Time time zone and is used in: North America. This time zone is often called Central Daylight Time. Thats why we have deducted -5 hrs from UTC. Read the below reference for further detailed information https://www.timeanddate.com/time/zones/cdt

Mayank · Answer

Amit When I run the code date converts from May 16 2010 7:20:12 AM CDT to 5/16/2010 5:50:12 PM .If we compare it with datetime.now then it is correct or not because time changes from 7:20:12 AM to 5:50:12 PM?

Amit Gupta · Answer

@Mayank Please read the below link https://en.m.wikipedia.org/wiki/Central_Time_Zone#Central_Daylight_Time

Mayank · Answer

Hi Amit Can you explain me your answer What is the requirement of below code? dts.Replace( CDT  -05:00 ) I have gone through the link mentioned by you but I was not able to understand the logic behind code.

Rafnas T P · Answer

string date=May 16 2010 7:20:12 AM CDT DateTime dtfromAPI=Convert.ToDateTime( date.Replace( CDT) ); then compare dtfromAPI with DateTime.Now() like below if(dtfromAPI >DateTime.Now()) { //... }

Amit Gupta · Answer

CDT - Central DateTime string dts = May 16 2010 7:20:12 AM CDT ; DateTime dt = DateTime.ParseExact(dts.Replace( CDT  -05:00 ) MMM dd yyyy H:mm:ss tt zzz  null ); Ref http://stackoverflow.com/questions/11873179/format-string-to-datetime-with-timezone

Mayank · Answer

Hi Sir My question is how can we compare with current date time?

Rafnas T P · Answer

timezone is not allowed in datetime

Mayank · Answer

Hi Below date is returning from API and it is a valid date. I need to compare with current date time.

Rafnas T P · Answer

what is CDT? remove CDT string date=May 16 2010 7:20:12 AM CDT  this is not a correct format thats why you are getting error it should be string date=May 16 2010 7:20:12 AM