Convert Local Time to UTC in SQL Server 2005

Asked Feb 07 '15 at 11:40

Active Feb 07 '15 at 13:14

Viewed 65 times

Can you help me on how to convert local time to UTC in SQL Server?

I know there is equivalent to C# but what I need is in SQL Server. The timezone is PACIFIC STANDARD TIME.

For example:

Local Time: "2015-02-02 15:34:23"

UTC: "2015-02-02 23:34:23"

Thank you!

I know it's been asked but it's in SQL Server 2008. What I need is in SQL Server 2005.

edited Feb 07 '15 at 13:14

asked Feb 07 '15 at 11:40

Ann

Thanks for the reference. Will try first. – Ann Feb 07 '15 at 12:03
do you want to convert it in a select query ? – Arunprasanth K V Feb 07 '15 at 12:14
Yes, that's exactly what I need to do. – Ann Feb 07 '15 at 12:52
Please take note, I'm dealing with SQL Server 2005. – Ann Feb 07 '15 at 12:57
My answer here https://stackoverflow.com/questions/8038744/convert-datetime-column-from-utc-to-local-time-in-select-statement/57710501#57710501 may help you – Elliveny Aug 30 '19 at 06:33

0 Answers0