Getting result in local time from UTC

[rookiesql]

Hi!
I am retreiving data from a MS SQL 2000 DB to my EXCEL spreadsheet and this goes well using a SQL query from inside EXCEL. However, I have discovered that the returned data for timestamps is in UTC format while my time zone is CET. I scanned the web for info and found that there is an expression like SELECT ....AT TIME ZONE ...
However, I couldn't get that to work in my SQL query. In my query I want to retrieve a column T1.received_date in local time format.
Has anybody been doing these conversions from UTC and knows how the SQL statement should be written?
Regards
Anders

 

[JayKusch]

Have you tried using GETUTCDATE()?



Thanks

J. Kusch

 

[SQLBill]

GETUTCDATE() is the equivelant of GETDATE().

But to convert your datetime field from UTC to local time, you'll need to script it:

SELECT DATEADD(hour, -1, t1.received_date)

That will subtract one hour from the t1.received_date field. You can make it a positive or negative number depending on the difference between your local time and UTC.

-SQLBill