I was just wondering if there is a need of TimeSpan in `java.util` so that I can define how much hours,minutes and seconds are there in between these two times.

From this `TimeSpan` we can have a time interval between two times. like

    TimeSpan getTimeSpan( Date before, Date after ){...}

or 

    long timeSpan = System.currentTimeMillis();
    // ... long job
    timeSpan = System.currentTimeMillis() - timeSpan;
    
    TimeSpan ts = new TimeSpan(timeSpan);

and with this `TimeSpan` we can use it in `SimpleDateFormat`.

    SimpleDateFormat format = new SimpleDateFormat(&quot;HH:mm:ss&quot;);
    format.format( timsSpan );

I am not sure if this is already been implemented in Java but yet undiscovered by me.

Do we have a TimeSpan sort of class in Java

&gt; **Possible Duplicate:**  
&gt; [How do I calculate someone&amp;rsquo;s age in C#?](https://stackoverflow.com/questions/9/how-do-i-calculate-someones-age-in-c)  

&lt;!-- End of automatically inserted text --&gt;

I want to calculate basically the age of employees -  So we have DOB for each employee, So on 
the C# Side I want to do something like this -

    int age=Convert.Int32(DateTime.Now-DOB);

I can use days and manipulate then get the age...but I wanted to know if there something I can use directly to get the number of years.


Calculate the difference between two dates and get the value in years?

How long is a .NET DateTime/TimeSpan tick?

I would like to know if there is a way to convert a 24 Hour time formatted string to a TimeSpan.

Right now I have a &quot;old fashion style&quot;:

    string stringTime = &quot;07:35&quot;;
    string[] values = stringTime.Split(&#39;:&#39;);
    
    TimeSpan ts = new TimeSpan(values[0], values[1], 0);



How to Convert string &quot;07:35&quot; (HH:MM) to TimeSpan

I am trying to store a .Net `TimeSpan` in SQL server 2008 R2. 

EF Code First seems to be suggesting it should be stored as a `Time(7)` in SQL. 

However `TimeSpan` in .Net can handle longer periods than 24 hours. 

What is the best way to handle storing .Net `TimeSpan` in SQL server?

What is the correct SQL type to store a .Net Timespan with values &gt; 24:00:00?

I am retrieving two date time values from the database. Once the value is retrieved, I need the difference between the two values.
For that, I create a timespan variable to store the difference of the 2 date values.
     

    TimeSpan? variable = datevalue1 - datevalue2;

Now i need to show the difference which is stored in the Timespan variable in terms of number of hours.
I referred to [TimeSpan.TotalHours][1] but couldn&#39;t apply the same for some reason.
How do I do that?
I am using C# on a MVC project. I simple need to show the difference value in hours?

**EDIT:
Since timespan was nullable, i couldn&#39;t use the total hours property. Now I can use it by doing TimeSpanVal.Value.TotalHours**;


  [1]: http://msdn.microsoft.com/en-us/library/system.timespan.totalhours.aspx

Showing Difference between two datetime values in hours

I am trying to serialize a .NET `TimeSpan` object to XML and it is not working. A quick google has suggested that while `TimeSpan` is serializable, the `XmlCustomFormatter` does not provide methods to convert `TimeSpan` objects to and from XML.

One suggested approach was to ignore the `TimeSpan` for serialization, and instead serialize the result of `TimeSpan.Ticks` (and use `new TimeSpan(ticks)` for deserialization). An example of this follows:

    [Serializable]
    public class MyClass
    {
        // Local Variable
        private TimeSpan m_TimeSinceLastEvent;

        // Public Property - XmlIgnore as it doesn&#39;t serialize anyway
        [XmlIgnore]
        public TimeSpan TimeSinceLastEvent
        {
            get { return m_TimeSinceLastEvent; }
            set { m_TimeSinceLastEvent = value; }
        }

        // Pretend property for serialization
        [XmlElement(&quot;TimeSinceLastEvent&quot;)]
        public long TimeSinceLastEventTicks
        {
            get { return m_TimeSinceLastEvent.Ticks; }
            set { m_TimeSinceLastEvent = new TimeSpan(value); }
        }
    }

While this appears to work in my brief testing - is this the best way to achieve this?

Is there a better way to serialize a TimeSpan to and from XML?

How to serialize a TimeSpan to XML

Using .NET 3.5

I want to determine if the current time falls in a time range.

So far I have the currentime:

    DateTime currentTime = new DateTime();
    currentTime.TimeOfDay;

I&#39;m blanking out on how to get the time range converted and compared.
Would this work?

    if (Convert.ToDateTime(&quot;11:59&quot;) &lt;= currentTime.TimeOfDay 
        &amp;&amp; Convert.ToDateTime(&quot;13:01&quot;) &gt;= currentTime.TimeOfDay)
    {
       //match found
    }
                

UPDATE1: Thanks everyone for your suggestions.  I wasn&#39;t familiar with the TimeSpan function.

Find if current time falls in a time range

In C#/.NET `TimeSpan` has `TotalDays`, `TotalMinutes`, etc. but I can&#39;t figure out a formula for total months difference. Variable days per month and leap years keep throwing me off. How can I get **TotalMonths**?

**Edit** Sorry for not being more clear: I know I can&#39;t actually get this from `TimeSpan` but I thought using `TotalDays` and `TotalMinutes` would be a good example to express what I was looking for ... except I&#39;m trying to get Total Months.

Example: Dec 25, 2009 - Oct 6, 2009 = 2 TotalMonths. Oct 6th to Nov 5th equals 0 months. On Nov 6th, 1 month. On Dec 6th, 2 months

calculating the difference in months between two dates

Both of these generate an error saying they must be a compile-time constant:

    void Foo(TimeSpan span = TimeSpan.FromSeconds(2.0))
    void Foo(TimeSpan span = new TimeSpan(2000))

First of all, can someone explain why these values can&#39;t be determined at compile time? And is there a way to specify a default value for an optional TimeSpan object?

C# 4.0: Can I use a TimeSpan as an optional parameter with a default value?

I want to know how much time a procedure/function/order takes to finish, for testing purposes.

This is what I did but my method is wrong &#39;cause if the difference of seconds is 0 can&#39;t return the elapsed milliseconds:

Notice the sleep value is 500 ms so elapsed seconds is 0 then it can&#39;t return milliseconds.

        Dim Execution_Start As System.DateTime = System.DateTime.Now
        Threading.Thread.Sleep(500)

        Dim Execution_End As System.DateTime = System.DateTime.Now
        MsgBox(String.Format(&quot;H:{0} M:{1} S:{2} MS:{3}&quot;, _
        DateDiff(DateInterval.Hour, Execution_Start, Execution_End), _
        DateDiff(DateInterval.Minute, Execution_Start, Execution_End), _
        DateDiff(DateInterval.Second, Execution_Start, Execution_End), _
        DateDiff(DateInterval.Second, Execution_Start, Execution_End) * 60))

Can someone show me a better way to do this? Maybe with a `TimeSpan`?

The solution:

    Dim Execution_Start As New Stopwatch
    Execution_Start.Start()

    Threading.Thread.Sleep(500)

    MessageBox.Show(&quot;H:&quot; &amp; Execution_Start.Elapsed.Hours &amp; vbNewLine &amp; _
           &quot;M:&quot; &amp; Execution_Start.Elapsed.Minutes &amp; vbNewLine &amp; _
           &quot;S:&quot; &amp; Execution_Start.Elapsed.Seconds &amp; vbNewLine &amp; _
           &quot;MS:&quot; &amp; Execution_Start.Elapsed.Milliseconds &amp; vbNewLine, _
           &quot;Code execution time&quot;, MessageBoxButtons.OK, MessageBoxIcon.Information)

Measuring code execution time

I have two DateTime vars, beginTime and endTime. I have gotten the difference of them by doing the following:

    TimeSpan dateDifference = endTime.Subtract(beginTime);

How can I now return a string of this in hh hrs, mm mins, ss secs format using C#.

If the difference was 00:06:32.4458750

It should return this 00 hrs, 06 mins, 32 secs

  [1]: https://stackoverflow.com/questions/840120/timespan-formatting

How do I convert a TimeSpan to a formatted string?

I have a ticks value of 28000000000 which should be 480 minutes but how can I be sure? How do I convert a ticks value to minutes?

How do I convert ticks to minutes?

How do I multiply a TimeSpan object in C#? Assuming the variable `duration` is a [TimeSpan](http://msdn.microsoft.com/en-us/library/system.timespan.aspx), I would like, for example

    duration*5

But that gives me an error &quot;operator * cannot be applied to types TimeSpan and int&quot;. Here&#39;s my current workaround

    duration+duration+duration+duration+duration

But this doesn&#39;t extend to non-integer multiples, eg. `duration * 3.5`    

Multiply TimeSpan in .NET

I need to merge two pandas dataframes on an identifier and a condition where a date in one dataframe is between two dates in the other dataframe.

Dataframe A has a date (&quot;fdate&quot;) and an ID (&quot;cusip&quot;):

![enter image description here][1]

I need to merge this with this dataframe B:

![enter image description here][2]

on `A.cusip==B.ncusip` and `A.fdate` is between `B.namedt` and `B.nameenddt`.

In SQL this would be trivial, but the only way I can see how to do this in pandas is to first merge unconditionally on the identifier, and then filter on the date condition:

    df = pd.merge(A, B, how=&#39;inner&#39;, left_on=&#39;cusip&#39;, right_on=&#39;ncusip&#39;)
    df = df[(df[&#39;fdate&#39;]&gt;=df[&#39;namedt&#39;]) &amp; (df[&#39;fdate&#39;]&lt;=df[&#39;nameenddt&#39;])]

Is this really the best way to do this? It seems that it would be much better if one could filter within the merge so as to avoid having a potentially very large dataframe after the merge but before the filter has completed.

  [1]: http://i.stack.imgur.com/qQ3UB.png
  [2]: http://i.stack.imgur.com/z6ESB.png
  [3]: http://stackoverflow.com/questions/29802022/pandas-dataframe-merge-between-two-values-instead-of-matching-one

Merge pandas dataframes where one value is between two others

I want to convert a Timespan to Datetime. How can I do this?

I found one method on Google:

    DateTime dt;
    TimeSpan ts=&quot;XXX&quot;;

    //We can covnert &#39;ts&#39; to &#39;dt&#39; like this:

    dt= Convert.ToDateTime(ts.ToString());

Is there any other way to do this?

TimeSpan to DateTime conversion

In the example below, why does the `Milliseconds` property return `0` but the `TotalMilliseconds` property return `5000`?

    // 5 seconds
    TimeSpan intervalTimespan = new TimeSpan(0, 0, 5);
    
    // returns 0
    intervalTimespan.Milliseconds;
    
    // returns 5000.0
    intervalTimespan.TotalMilliseconds

C# Timespan Milliseconds vs TotalMilliseconds

Is it ever OK to use `Environment.TickCount`to calculate time spans?

    int start = Environment.TickCount;
    // Do stuff
    int duration = Environment.TickCount - start;
    Console.WriteLine(&quot;That took &quot; + duration &quot; ms&quot;);

Because `TickCount` is signed and will rollover after 25 days (it takes 50 days to hit all 32 bits, but you have to scrap the signed bit if you want to make any sense of the math), it seems like it&#39;s too risky to be useful. 

I&#39;m using `DateTime.Now` instead. Is this the best way to do this?

    DateTime start = DateTime.Now;
    // Do stuff
    TimeSpan duration = DateTime.Now - start;
    Console.WriteLine(&quot;That took &quot; + duration.TotalMilliseconds + &quot; ms&quot;);



Environment.TickCount vs DateTime.Now

I would like to format some commands execution times in a human readable format, for example:

    3 -&gt; 3ms
    1100 -&gt; 1s 100ms
    62000 -&gt; 1m 2s
    etc ..

Taking into account days, hours, minutes, seconds, ...

Is it possible using `C#`?

Convert milliseconds to human readable time lapse

## Basic problem

I have a bunch of records and I need to get latest (most recent) and the oldest (least recent).

When googling I found [this topic](https://groups.google.com/forum/?fromgroups=#!searchin/mongoose-orm/oldest/mongoose-orm/z93TqQ2lHJ0/PdBpnZ-HPVEJ) where I saw a couple of queries:

    // option 1
    Tweet.findOne({}, [], { $orderby : { &#39;created_at&#39; : -1 } }, function(err, post) {
      console.log( post );
    });
    // option 2
    Tweet.find({}, [], {sort:[[&#39;arrival&#39;,-1]]}, function(err, post) {
      console.log( post );
    });

Unfortunatly they both error:

    TypeError: Invalid select() argument. Must be a string or object.

The link also has this one:

    Tweet.find().sort(&#39;_id&#39;,&#39;descending&#39;).limit(15).find(function(err, post) {
      console.log( post );
    });

and that one errors:

    TypeError: Invalid sort() argument. Must be a string or object.

So how can I get those records?

## Timespan

Even more ideally I just want the difference in time (seconds?) between the oldest and the newest record, but I have no clue on how to start making a query like that.

This is the schema:

    var Tweet = new Schema({
	    body: String
	  , fid: { type: String, index: { unique: true } }
	  , username: { type: String, index: true }
	  , userid: Number
	  , created_at: Date
	  , source: String
	});

I&#39;m pretty sure I have the most recent version of mongoDB and mongoose.

## EDIT

This is how I calc the timespan based on the answer provided by JohnnyHK:

    var calcDays = function( cb ) {
      var getOldest = function( cb ) {
        Tweet.findOne({}, {}, { sort: { &#39;created_at&#39; : 1 } }, function(err, post) {
          cb( null, post.created_at.getTime() );
        });
      }
        , getNewest = function( cb ) {
        Tweet.findOne({}, {}, { sort: { &#39;created_at&#39; : -1 } }, function(err, post) {
          cb( null, post.created_at.getTime() );
        });
      }

      async.parallel({ 
        oldest: getOldest
      , newest: getNewest
      }
        , function( err, results ) {
          var days = ( results.newest - results.oldest ) / 1000 / 60 / 60 / 24;
          // days = Math.round( days );
          cb( null, days );
        }
      );
    }

How to get the latest and oldest record in mongoose.js (or just the timespan between them)

I would like to know a simple algorithm to check if the given instance of `datetime` lies between another two instances in `C#`.

**Note:**

I skimmed though this https://stackoverflow.com/questions/2634127/how-do-i-check-if-a-given-datetime-object-is-between-two-datetimes and it was for python and many more for php. Most of the other questions were regarding difference between the two.

**Details:**

I am more specific about the time, date does not matter to me. For example i got `DataBase` entry for a staff who works between `10:00` Am - `9:00` Pm and I would like to know which staff is engaged in class at the given time like `2:00 Pm`. Now this would return me the staff&#39;s details who are engaged at this time.

**Edit**

After accepting the answer(been more than year back), i realized i had incorrectly described the problem. But all i think that was to be done back then was to do date and time comparison. So answers by both Jason and VikciaR work. 

Check if datetime instance falls in between other two datetime objects

I have a collection of objects that include a TimeSpan variable:

    MyObject
    { 
        TimeSpan TheDuration { get; set; }
    }

I want to use LINQ to sum those times.
Of course, (from r in MyCollection select r.TheDuration).Sum(); doesn&#39;t work!

I&#39;m thinking of changing the datatype of TheDuration to an int and then summing it and converting the sum to a TimeSpan. That will be messy because each TheDuration in my collection is used in as a timespan somewhere else.

Any suggestion on this summation?

Sum of TimeSpans in C#

I have two textboxes. One for a clock in time and one for clock out. The times will be put in this format:

    Hours:Minutes

Lets say I have clocked in at 7:00 AM and clocked out at 2:00 PM.

With my current code, I get a difference of 2 hours, but it should be 7 hours. How would I do that in C#. I was going to convert to the 24 hour, by letting the user select AM or PM, but I got confused.

So, basically, how would I calculate the difference of hours between the two times?

I tried this, but got 2 hours and not 7 when I plugged in the numbers.

    DateTime startTime = Convert.ToDateTime(textBox1.Text);
    DateTime endtime = Convert.ToDateTime(textBox2.Text);

    TimeSpan duration = startTime - endtime;

Getting time span between two times in C#?

I have timespans:

&gt; String time1 = 01:00:00 
&gt;
&gt; String time2 = 05:00:00

I want to check if **time1** and **time2** both lies between `20:11:13 and 14:49:00`.

Actually, `01:00:00` is greater than `20:11:13` and less than `14:49:00` considering `20:11:13` is always less than `14:49:00`. This is given prerequisite. 

So what I want is, `20:11:13 &lt; 01:00:00 &lt; 14:49:00`.

So I need something like that:

     public void getTimeSpans()
    {
        boolean firstTime = false, secondTime = false;
        
        if(time1 &gt; &quot;20:11:13&quot; &amp;&amp; time1 &lt; &quot;14:49:00&quot;)
        {
           firstTime = true;
        }
        
        if(time2 &gt; &quot;20:11:13&quot; &amp;&amp; time2 &lt; &quot;14:49:00&quot;)
        {
           secondTime = true;
        }
     }

I know that this code does not give correct result as I am comparing the string objects.

How to do that as they are the timespans but not the strings to compare?

Check if a given time lies between two times regardless of date

I have collection of TimeSpans, they represent time spent doing a task. Now I would like to find the average time spent on that task. It should be easy but for some reason I&#39;m not getting the correct average.

Here&#39;s my code:

    private TimeSpan? GetTimeSpanAverage(List&lt;TimeSpan&gt; sourceList)
    {
        TimeSpan total = default(TimeSpan);

        var sortedDates = sourceList.OrderBy(x =&gt; x);

        foreach (var dateTime in sortedDates)
        {
            total += dateTime;
        }
        return TimeSpan.FromMilliseconds(total.TotalMilliseconds/sortedDates.Count());
    }

All Timespan Solutions on Gang of Coders

Total of 25 Timespan Solutions