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