sql - How can i convert numeric value to datetime? -

i have sql database

table name    :   tb_event_log columns name :   ndatetime,nuserid 

column ndatetime has anumeric values

1433923965,1433865660,1433841912,....

i want convert values in ndatetime column date , time values

and preview in datagridview

the example values provided can interpreted seconds since 1970-01-01 00:00:00 utc (the unix epoch). depends on programming environment how convert these values presentable formats. involves creation of date(/time) objects right constructor, or formatting right format string.