How to Convert Timestamp to DateTime?

Question

I want to convert epoch to human readable date and vice versa.
I want to write something similar to link in C#.

Converting the date in the places.sqlite file in Firefox to a DateTime.

static void Main(string[] args)
{
    //1540787809621000
    string epoch = "1540787809621000";
}

private string epoch2string(int epoch) {
    return 
        new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc)
            .AddSeconds(epoch)
            .ToShortDateString(); 
}

int size Not enough I try long epoch but not work

[DateTimeOffset.FromUnixTimeSeconds(Int64) Method](https://docs.microsoft.com/en-us/dotnet/api/system.datetimeoffset.fromunixtimeseconds?redirectedfrom=MSDN&view=netframework-4.7.2#System_DateTimeOffset_FromUnixTimeSeconds_System_Int64_) — Drag and Drop, Oct 30 '18 at 09:30
Possible duplicate of [How can I convert a Unix timestamp to DateTime and vice versa?](https://stackoverflow.com/questions/249760/how-can-i-convert-a-unix-timestamp-to-datetime-and-vice-versa) — Drag and Drop, Oct 30 '18 at 09:30
Thank you very much. I'm not good at English. But I will try to communicate. new post Below — Thanawut Padermwong, Oct 30 '18 at 09:31
@ThanawutPadermwong, when you have to add information to your question use the [edit] button on the bottom of your post. The answer box are for answer not for clarification. — Drag and Drop, Oct 30 '18 at 09:33

score 5 · Accepted Answer · answered Oct 30 '18 at 09:29

5

Your time is a Unix time in microseconds.

If you are using .Net 4.6 or later, you can convert this to a DateTime as follows.

long time = 1540787809621000; // Unix time in microseconds.

time /= 1000; // Divide by 1,000 because we need milliseconds, not microseconds.

DateTime result = DateTimeOffset.FromUnixTimeMilliseconds(time).DateTime;

Console.WriteLine(result); // Prints 29/10/2018 04:36:49 (UK format)

answered Oct 30 '18 at 09:29

Matthew Watson

96,889
9
144
240

3

thank you old brother time/1000 because milliseconds – Thanawut Padermwong Oct 30 '18 at 09:34
1

Are you family? Who knew given your names... @ThanawutPadermwong – Patrick Hofman Oct 30 '18 at 09:37
what's Who knew given your names. i'm sorry i do not understand – Thanawut Padermwong Oct 31 '18 at 05:03

score 2 · Answer 2 · answered Apr 28 '20 at 08:04

2

timestamp is amount of seconds from 1/1/1970

static DateTime ConvertFromUnixTimestamp(double timestamp)
{
    DateTime origin = new DateTime(1970, 1, 1, 0, 0, 0, 0);
    return origin.AddSeconds(timestamp);
}

answered Apr 28 '20 at 08:04

Divyesh_08

1,563
15
25

Thanawut Padermwong · Answer 3 · 2020-03-16T18:24:17.193

-1

This example I fix it

    static void Main(string[] args)
    {
        //1540787809621000
        int epoch = "1540787809621000"; //this microseconds 
        epoch /= 1000; // convert to milliseconds by divide 1000  
        epoch2string(epoch) 
    }

private string epoch2string(int epoch) {
return new DateTime(1970, 1, 1, 0, 0, 0, DateTimeKind.Utc).AddSeconds(epoch).ToShortDateString(); }

edited Mar 16 '20 at 18:24

answered Oct 30 '18 at 09:30

Thanawut Padermwong

66
1
1
8

1

Please edit your question instead of posting an update as an answer. I have done this for you now. – Patrick Hofman Oct 30 '18 at 09:39

How to Convert Timestamp to DateTime?

3 Answers3