Convert Unix Epoch Time to Seconds in SQL or .NET

Posted by user293249 on Stack Overflow See other posts from Stack Overflow or by user293249
Published on 2010-05-01T00:03:57Z Indexed on 2010/05/01 0:07 UTC
Read the original article Hit count: 270

Filed under:
|
|
|
|

First let me thank you all for your help.

What I need is a function that takes in a EPOCH time stamp, like 1452.235687 and converts it to a readable timestamp like '01-01-1970 00:00:00'. More specifically I only need the time not the date.

If at all possible I would prefer a .NET function instead of a SQL stored procedure. However an SQL stored procedure would work fine as well.

Thank you again,

© Stack Overflow or respective owner

Related posts about sql

Related posts about .NET