I am working with pandas’ tz_localize function to convert dates from local time to UTC: time_zone = ‘America/Santiago’ pd.to_datetime(pd.to_datetime(df[‘mydate’]).apply(lambda x: datetime.strftime(x, ‘%d-%m-%Y %H:%M:%S’))).dt.tz_localize(time_zone).dt.tz_convert(‘UTC’).dt.tz_localize(None) This works well, but now I would like to check whether the user-defined time_zone actually exists prior to passing it into tz_localize. I found lists of available countries online, but I do… Read More How to test whether timezone exists in Python/pandas?

I have this start date : 2023-09-03T00:00:00+05:30 and end date : 2023-09-10T00:00:00+05:30 I want to subtract 90 days from start date and add 90 days from end date and then convert it to UTC format for that I was using this function in angular moment(startStr, ‘YYYY-MM-DD hh:mm:ss’).utc().format(‘YYYY-MM-DD hh:mm:ss’); moment(endStr, ‘YYYY-MM-DD hh:mm:ss’).utc().format(‘YYYY-MM-DD hh:mm:ss’); How can I… Read More Add and subtract 3 month from a given date time

How do I calculate the difference between two UTC times in hours? This is what I have tried: lastSuccessfulRunTime // UTC Time int timeDifference = (DateTime.UtcNow – lastSuccessfulRunTime).Hours if (DateTime.UtcNow – lastSuccessfulRunTime) = 9.00:00:00.7944388, timeDifference will be 0 which is not what I need. >Solution : The Hours property returns the integer hours value of… Read More calculate the difference between two UTC times in hours C#

I have tried to create a method to format some dates in my datatable which are based on the results from a sql server of ours. I cannot see any reason why certain dates would draw an error and the errors seem to be from my if statements. For instance when checking the month and… Read More getUTCMonth() and getUTCDate draws an error when comparing certain dates

I would like to transform a UTC timestamp with 5-6 ms digits into a SQL Server datetime. I do not want to localize or anything, just want to keep UTC but turn it into a datetime e.g. declare @utc_timestamp varchar(20) = ‘2022-10-05T13:12:02.000402Z’; — Desired datetime format (is this even possible or does this not conform… Read More Convert string timestamp in format yyyy-MM-ddTHH:mm:ss.ffffffZ to SQL Server datetime without changing time zone

I have a date string coming from back-end as "2022-08-16T13:44:11.8743234". Date formatting and conversion is the oldest skill in the book but I cannot figure out why I’m unable to convert that string to a Date object in Swift iOS. I just get nil with any source format I specify. private func StringToDate(dateString: String) ->… Read More DateTime2 formart conversion to Swift Date