C# convert dates to Timestamp

Question

I got a date in the below format: 2014-07-18

I need the unixTimeStamp of this date like PHP gives. I want to store those in a msAccess table which I can later sort on this timestamp value.

PHP returns this timestamp for the above date: 1405641600

How can I do this?

Thanks

Is that timestamp correct? It should be 1405641600 http://unixtimesta.mp/1405641600 — Anthony Chu, Jul 19 '14 at 06:53

score 5 · Answer 1 · edited Nov 26 '18 at 06:52

Usually i use this extension:

public static class Extensions
{
     public static  double ToUnixTime(this DateTime input)
     {
         return input.Subtract(new DateTime(1970,1,1)).TotalSeconds;
     }
}

As you mention in question, you need PHP like TimeStamp, so you will need to round TotalSeconds(it's double right now):

public static class Extensions
{
     public static int ToUnixTime(this DateTime input)
     {
         return (int)input.Subtract(new DateTime(1970,1,1)).TotalSeconds;
     }
}

score 4 · Accepted Answer · edited Apr 12 '21 at 13:43

4

Yep I think Anthony Chu is correct. I used the following site to check:

http://www.unixtimestamp.com/index.php

And it gave the answer 1405641600.

I also did the following C# to get the same answer for your example date:

var baseDate = new DateTime (1970, 01, 01);
var toDate = new DateTime (2014, 07, 18);
var numberOfSeconds = toDate.Subtract (baseDate).TotalSeconds;

edited Apr 12 '21 at 13:43

Thomas Ayoub

29,063
15
95
142

answered Jul 19 '14 at 07:17

Ben Franklin

626
6
21

C# convert dates to Timestamp

2 Answers2