Sounds like you need moment.js e.g. moment().subtract(‘days’, 6).calendar(); => last Sunday at 8:23 PM moment().startOf(‘hour’).fromNow(); => 26 minutes ago Edit: Pure JS date diff calculation: var date1 = new Date(“7/Nov/2012 20:30:00”); var date2 = new Date(“20/Nov/2012 19:15:00”); var diff = date2.getTime() – date1.getTime(); var days = Math.floor(diff / (1000 * 60 * 60 * 24)); … Read more
As you’ve found out yourself, it’s a documented feature. It’s described in the documentation of TimeSpan: Parameters value Type: System.Double A number of seconds, accurate to the nearest millisecond. The reason for this is probably because a double is not that accurate at all. It is always a good idea to do some rounding when … Read more
[Browsable(false)] [EditorBrowsable(EditorBrowsableState.Never)] [Obsolete(“Property ‘” + nameof(Duration) + “‘ should be used instead.”)] public long DurationTicks { get; set; } [NotMapped] public TimeSpan Duration { #pragma warning disable 618 get { return new TimeSpan(DurationTicks); } set { DurationTicks = value.Ticks; } #pragma warning restore 618 } Update This is now achievable since EF Core 2.1, using … Read more
You can use lateaftertime.Duration() to get a non-negative span.
myTimeSpan.ToString(@”hh\:mm”) Custom TimeSpan Format Strings The custom TimeSpan format specifiers do not include placeholder separator symbols, such as the symbols that separate days from hours, hours from minutes, or seconds from fractional seconds. Instead, these symbols must be included in the custom format string as string literals. For example, “dd.hh\:mm” defines a period (.) as … Read more
You can use someDateTime.Subtract(otherDateTime), this returns a TimeSpan which has a TotalDays property.
Here’s a fun hacky way to do exactly what you are looking for =) date -u -d @${i} +”%T” Explanation: The date utility allows you to specify a time, from string, in seconds since 1970-01-01 00:00:00 UTC, and output it in whatever format you specify. The -u option is to display UTC time, so it … Read more
As you say, this is pretty easy in SQL, so why not do it in SQL? import pandas as pd import sqlite3 #We’ll use firelynx’s tables: presidents = pd.DataFrame({“name”: [“Bush”, “Obama”, “Trump”], “president_id”:[43, 44, 45]}) terms = pd.DataFrame({‘start_date’: pd.date_range(‘2001-01-20′, periods=5, freq=’48M’), ‘end_date’: pd.date_range(‘2005-01-21′, periods=5, freq=’48M’), ‘president_id’: [43, 43, 44, 44, 45]}) war_declarations = pd.DataFrame({“date”: [datetime(2001, … Read more
Well, the simplest thing to do is to format this yourself, e.g. return string.Format(“{0}hr {1}mn {2}sec”, (int) span.TotalHours, span.Minutes, span.Seconds); In VB: Public Shared Function FormatTimeSpan(span As TimeSpan) As String Return String.Format(“{0}hr {1}mn {2}sec”, _ CInt(Math.Truncate(span.TotalHours)), _ span.Minutes, _ span.Seconds) End Function I don’t know whether any of the TimeSpan formatting in .NET 4 would … Read more
These can all be done with DateTime.Add(TimeSpan) since it supports positive and negative timespans. DateTime original = new DateTime(year, month, day, 8, 0, 0); DateTime updated = original.Add(new TimeSpan(5,0,0)); DateTime original = new DateTime(year, month, day, 17, 0, 0); DateTime updated = original.Add(new TimeSpan(-2,0,0)); DateTime original = new DateTime(year, month, day, 17, 30, 0); DateTime … Read more