Groups > comp.databases.ms-sqlserver > #935

Datetime with timezone information in it?

Newsgroups	comp.databases.ms-sqlserver
Subject	Datetime with timezone information in it?
From	Antti J=?iso-8859-1?B?5A==?=rvinen <costello@iki.fi>
Date	2012-03-02 10:41 +0200
Message-ID	<m3d38v5r9t.fsf@muikku.katiska.org> (permalink)
Organization	FINNET customers

Show all headers | View raw

Dear Sirs,

I tried briefly looking through docs but I could not find definite answer: 
is there database column datatype that would save date, time and the 
timezone as a single value? I have an app that is supposed to run 24/7 
and having those daylight saving timezone-changes occurring twice a 
year hoses up couple of things twice a year.

I still have the (good) option of saving time info as seconds since beginning
of year 1970 and having timezone conversions done at client end
but that's not that convenient -> what is the correct way to handle
this around with ms sql server (clients will be .net and asp.net thingies).
The DATETIMEOFFSET of 2008 version did not look too handy to me, 
anything else? 

-- 
Costello the Warrior        St:18/09 Dx:14 Co:18 In:8 Wi:12 Ch:7  Neutral
Dlvl:16 $:0  HP:129(129) Pw:52(52) AC:-6 Xp:14/83896 T:19462 Satiated

Back to comp.databases.ms-sqlserver | Previous | Next — Next in thread | Find similar

Thread

Datetime with timezone information in it? Antti J=?iso-8859-1?B?5A==?=rvinen <costello@iki.fi> - 2012-03-02 10:41 +0200
  Re: Datetime with timezone information in it? Erland Sommarskog <esquel@sommarskog.se> - 2012-03-02 10:37 +0000
    Re: Datetime with timezone information in it? Antti J=?iso-8859-1?B?5A==?=rvinen <costello@iki.fi> - 2012-03-02 15:46 +0200
      Re: Datetime with timezone information in it? Erland Sommarskog <esquel@sommarskog.se> - 2012-03-02 17:22 +0000
        Re: Datetime with timezone information in it? Justin <kfwolf@hotmail.com> - 2012-03-08 06:37 -0800

csiph-web