DIffrent Time Zone - SQL Server Forums

Please start any new threads on our new site at https://forums.sqlteam.com. We've got lots of great SQL Server experts to answer whatever question you can come up with.

All Forums

General SQL Server Forums

New to SQL Server Programming

DIffrent Time Zone

Author

Topic

sanjay5219
Posting Yak Master

240 Posts

Posted - 2011-09-04 : 14:11:24

Hi All,

Is there any query to tell me the time in diffrent format
IST
CST
EST
MST

Please suggest

tkizer
Almighty SQL Goddess

38200 Posts

Posted - 2011-09-04 : 14:45:44

You'll need to either find a timezone converted function (I've posted one a while back but did not post the correction when DST rules changed) or write one yourself.

We keep our server's timezone at GMT to make the conversion easiest.

Tara Kizer
Microsoft MVP for Windows Server System - SQL Server
http://weblogs.sqlteam.com/tarad/

Subscribe to my blog

SwePeso
Patron Saint of Lost Yaks

30421 Posts

Posted - 2011-09-04 : 15:16:30

You can use DATETIMEOFFSET datatype.

N 56°04'39.26"
E 12°55'05.63"

Subscribe to SQLTeam.com

SQLTeam.com Articles via RSS

SQLTeam.com Weblog via RSS

- Advertisement -

Resources