Is Unix time the value of a MYSQL timestamp data type? Correct code example to convert from C#?

Question

I found this sample source code for C# from How to convert a Unix timestamp to DateTime and vice versa?:

DateTime date = new DateTime(2011, 4, 1, 12, 0, 0, 0);

DateTime epoch = new DateTime(1970, 1, 1, 0, 0, 0, 0);

TimeSpan span = (date - epoch);

double unixTime =span.TotalSeconds.Dump();

If I was to insert into a MYSQL table the value of unixTime, would this be equivalent of a MYSQL timestamp datatype value? I just want to confirm this.

Can you post an example of what unixTime looks like? I don't know offhand what Dump does. — Chris Laplante
– Chris Laplante, Commented Nov 29, 2011 at 21:54
Sorry, I think unixTime should be double unixTime =span.TotalSeconds; — heavy rocker dude
– heavy rocker dude, Commented Nov 29, 2011 at 22:03

favoretti · Accepted Answer · 2011-11-29 22:07:48Z

1

It depends on the version of MySQL. TIMESTAMP field format has been changed from unixtime to dd-mm-yyyy hh:mm:ss from 5.something. If you want to insert a unixtime into a timestamp field, you should use FROM_UNIXTIME() builtin.

answered Nov 29, 2011 at 22:07

favoretti

30.4k4 gold badges52 silver badges62 bronze badges

Sign up to request clarification or add additional context in comments.

2 Comments

heavy rocker dude Over a year ago

Thanks. This is helpful but the question becomes could I pass to MYSQL's FROM_UNIXTIME(the value of unixTime) which is from the C# example above? I just want ensure my logic is correct.

favoretti Over a year ago

Should work from what I understand. Isn't it easier to just test? Insert a date and then do select from_unixtime(field) from table_you_inserted_it_to; ? :)

Collectives™ on Stack Overflow

Is Unix time the value of a MYSQL timestamp data type? Correct code example to convert from C#?

1 Answer 1

2 Comments

Your Answer

Linked

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

2 Comments

Your Answer

Sign up or log in

Post as a guest

Linked

Related