sql server - SQL Convert time in seconds into a local time zone -

i working on query time stored in seconds.

right string have shows following.

select schema.table.opendate_seconds, '19700101' open date 

that gets me sever time open. how can adjust central time?

thanks in advance looking , helping.