Mysql TimeStamp datatype

Question

I am developing a asp.net web application with ado.net entity framework and MySQL as backend. I have taken some columns in DB as timestamp datatype when I get date from DB these fields of timestamp datatype returns null. In application these fields are mapped as datetimeoffset.

possible duplicate of [How to convert UNIX timestamp to DateTime and vice versa?](http://stackoverflow.com/questions/249760/how-to-convert-unix-timestamp-to-datetime-and-vice-versa) — Konerak, Aug 25 '11 at 06:44

score 0 · Answer 1 · edited May 23 '17 at 12:04

0

See the accepted answer to this post

How to convert a Unix timestamp to DateTime and vice versa?

You need to adapt the timestamps into datetimeoffset objects in .net.

edited May 23 '17 at 12:04

Community

1
1

answered Aug 25 '11 at 06:39

Michael Christensen

1,768
1
13
11

Thanks for reply the prb is that date is saving properly in valid format only when i access data it return null – SMeha Aug 25 '11 at 06:42
Yes, I know. I think you need to adapt the timestamp from the database into a datetimeoffset. – Michael Christensen Aug 25 '11 at 17:37

Mysql TimeStamp datatype

1 Answers1