在Sqlserver 2005中将本地时间转换为UTC时间 [英] Convert Local Time To UTC Time in Sqlserver 2005

查看:181
本文介绍了在Sqlserver 2005中将本地时间转换为UTC时间的处理方法,对大家解决问题具有一定的参考价值,需要的朋友们下面随着小编来一起学习吧!

问题描述

尊敬的先生,
我已经下载了将本地时间转换为UTC时间的代码,但是此过程未返回正确答案,也没有印度ID.我希望任何类型的ID都意味着要说我们提供的TimeZone ID,本地日期应该是UTC格式的返回日期.请给我关于相同或是否有代码的逻辑,请告诉我.
谢谢.
Ashish Mishra
[DELETED] @ gmail.com

[edit]电子邮件已删除-OriginalGriff [/edit]

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]

推荐答案

您的问题似乎与特定的文章,提示或问题有关.该网站上有超过8,000,000个成员在贡献代码和文章.一定要在发布代码的地方张贴问题,这样原始作者可以为您提供帮助.

您可以在网站上的以下着陆点找到其他帮助,以解决此类转化:

SQL 2005时区转换功能 [ SQL Server-将UTC转换为本地时间 [
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.


这篇关于在Sqlserver 2005中将本地时间转换为UTC时间的文章就介绍到这了,希望我们推荐的答案对大家有所帮助,也希望大家多多支持IT屋!

查看全文
登录 关闭
扫码关注1秒登录
发送“验证码”获取 | 15天全站免登陆