SQL Convert time in seconds into a local time zone

Asked May 29 '14 at 20:39

Active May 29 '14 at 23:13

Viewed 52 times

I am working on query where time is stored in seconds.

Right now the string I have shows the following.

Select schema.table.OpenDate_Seconds, '19700101' as Open Date

That gets me the sever time for the Open. How can I adjust this to get Central Time?

Thanks in advance for looking and helping.

edited May 29 '14 at 23:13

asked May 29 '14 at 20:39

William T.

What's the server time zone? – Gilbert Le Blanc May 29 '14 at 20:44
What database are you using? – Joseph B May 29 '14 at 20:56
Using SQL Server 2008 R2 .. Server is Pacific Time, want report in Central time. – William T. May 29 '14 at 21:00
see this : http://stackoverflow.com/q/24797/3660930 – Ash May 29 '14 at 23:35

0 Answers0