c# - How to convert Timestamp to Date?

Question

I'm getting timestamp from xml document.Now, I want to convert Timestamp to Date format(13-May-13)

XmlNodeList cNodes = xncomment.SelectNodes("comment");
foreach (XmlNode node in cNodes)
{
    //I'm getting this "1372061224000" in comment-date
    string comment_date = node["creation-timestamp"].InnerText;
}

Any ideas? Thanks in advance.

is that a sql server timestamp value? If so, you should not be using as a datetime... — Mitch Wheat, Jun 26 '13 at 10:23
Is this what you were looking for: http://stackoverflow.com/q/11914243/1341477 — Dave Williams, Jun 26 '13 at 10:24
Possible Dupilcate of [This](http://stackoverflow.com/questions/11914243/convert-timestampdatetime-ticks-from-database-to-datetime-value-before-display) — Ashrith Sheshan, Jun 26 '13 at 10:24
Possible Duplicate: http://stackoverflow.com/questions/249760/how-to-convert-unix-timestamp-to-datetime-and-vice-versa — Chris, Jun 26 '13 at 10:25

Teoman Soygul · Accepted Answer · 2013-06-26T10:34:45.343

34

Given that this looks like a Java timestamp, simply use below:

var dt = new DateTime(1970, 1, 1, 0, 0, 0, 0).AddSeconds(Math.Round(1372061224000 / 1000d)).ToLocalTime();
Console.WriteLine(dt); // Prints: 6/24/2013 10:07:04 AM

edited Jun 26 '13 at 10:34

answered Jun 26 '13 at 10:24

Teoman Soygul

25,584
6
69
80

This isn't normal timestamp. please take care – Shady Mohamed Sherif Jan 31 '18 at 15:25

Sapnandu · Answer 2 · 2015-12-27T16:48:08.357

Finally i found how to convert time stamp to Date & Date to time stamp . I found some places in project people keep date as time stamp for get difference quickly. so in this case they use to keep the table column as Int or time stamp. now the problem is that in the application while showing the data, you need to convert it into date variable. So for that we can use the following code to convert time stamp to Date

int ts = 1451174400;
DateTime dt = new DateTime(1970, 1, 1, 0, 0, 0, 0).AddSeconds(ts).ToLocalTime();
string formattedDate = dt.ToString("dd-MM-yyyy");

Now you can get any date format from this variable.

In the second case if you want to convert Date to time stamp then check the following code.

int ts = (dt.Ticks - 621356166000000000) / 10000000;

Where dt is the date time variable & holding a date value.

this answer is prefect for normal time stamp – Shady Mohamed Sherif Jan 31 '18 at 15:26 — Shady Mohamed Sherif, Jan 31 '18 at 15:26
This is the first working answer in so many I have browsed. – Olorunfemi Davis Jul 04 '20 at 23:15 — Olorunfemi Davis, Jul 04 '20 at 23:15

score 2 · Answer 3 · answered Jun 26 '13 at 10:28

Maybe replace this :

    foreach (XmlNode node in cNodes)
{
    //I'm getting this "1372061224000" in comment-date
    string comment_date = node["creation-timestamp"].InnerText;
}

by :

foreach (XmlNode node in cNodes)
{
    Datetime comment_date = new DateTime(Convert.ToInt32(node["creation-timestamp"]);
}

score 1 · Answer 4 · edited Oct 25 '17 at 21:51

1

Thanks to all.

Finally I got the output

foreach (XmlNode node in cNodes)
{
    comment_timestamp = node["creation-timestamp"].InnerText;
    DateTime comment_date1 = new DateTime(Convert.ToInt64(comment_timestamp));
    comment_date = Convert.ToDateTime(comment_date1).ToString("dd-MMM-yy");
}

Output:

01-MAY-13

edited Oct 25 '17 at 21:51

FoggyFinder

2,230
2
20
34

answered Jun 26 '13 at 11:41

user2500094

1,033
6
23
42

score 0 · Answer 5 · answered Apr 23 '20 at 07:13

You can use FromUnixTimeSeconds method of DateTimeOffset

 var dateTime1 = new DateTime(2020, 4, 5, 12, 15, 12);//05.04.2020 12:15:12

 var timeStamp = new DateTimeOffset(dateTime1).ToUnixTimeSeconds(); //1586074512

If FromUnixTimeSeconds's result is not corresponding your original datetime, you can use LocalDateTime property of DateTimeOffset object.

 var dateTime2 = DateTimeOffset.FromUnixTimeSeconds(timeStamp).DateTime;//05.04.2020 08:15:12
 var dateTime3 = DateTimeOffset.FromUnixTimeSeconds(timeStamp).LocalDateTime;//05.04.2020 12:15:12

For more information please visit this link DateTimeOffset.FromUnixTimeSeconds(Int64) Method

c# - How to convert Timestamp to Date?

5 Answers5