Convert Local Time To UTC Time in Sqlserver 2005

Question

0.00/5 (No votes)

See more:

SQL-Server-2005

Respected Sir,
I have download the code to converting a local time to utc time but this procedure is not returning a correct answer as well as it has not India Id. I want that any type of ID mean to say TimeZone Id we provide and local date it should be return date into UTC format. Please Give me Logic about same or if have code please tell me.
Thanks.
Ashish Mishra
[DELETED]@gmail.com

[edit]Email deleted - OriginalGriff[/edit]

Posted 19-Aug-11 1:12am

a1986sitapur

Updated 19-Aug-11 1:31am

OriginalGriff

v2

Add a Solution

Comments

OriginalGriff 19-Aug-11 7:31am

Never post your email address in any forum, unless you really like spam! If anyone replies to you, you will receive an email to let you know

Corporal Agarn 19-Aug-11 7:56am

Please post your code.

1 solution

Add a Solution

Add your solution here

Treat my content as plain text, not as HTML

Preview 0

…

Existing Members

Sign in to your account

...or Join us

Download, Vote, Comment, Publish.

Your Email
Password
Forgot your password?

Your Email
This email is in use. Do you need your password?
Optional Password

I have read and agree to the Terms of Service and Privacy Policy
Please subscribe me to the CodeProject newsletters

When answering a question please:

Read the question carefully.
Understand that English isn't everyone's first language so be lenient of bad spelling and grammar.
If a question is poorly phrased then either ask for clarification, ignore it, or edit the question and fix the problem. Insults are not welcome.
Don't tell someone to read the manual. Chances are they have and don't get it. Provide an answer or move on to the next question.

Let's work to help developers, not make them feel stupid.

This content, along with any associated source code and files, is licensed under The Code Project Open License (CPOL)

TheyCallMeMrJames · Answer 1 · 2011-08-19T09:16:00

Your question seems to be about a specific article, tip or question. There are 8,000,000+ members on the site that contribute code and articles. Be sure to post your question where you got the code from as that way the original author can help you out.

You may find additional help at the following landing spots on the site that tackle this type of conversion:

SQL 2005 Time Zone Conversion Functions[^]

SQL Server - Convert UTC to Local Time[^]

Cheers.