Path: csiph.com!usenet.pasdenom.info!goblin1!goblin.stu.neva.ru!uio.no!fi.sn.net!newsfeed2.tdcnet.fi!news.song.fi!not-for-mail Newsgroups: comp.databases.ms-sqlserver Subject: Datetime with timezone information in it? From: Antti =?us-ascii?Q?J=3D=3Fiso-8859-1=3FB=3F5A=3D=3D=3F=3Drvinen?= Date: Fri, 02 Mar 2012 10:41:18 +0200 Message-ID: User-Agent: Gnus/5.1008 (Gnus v5.10.8) XEmacs/21.4.22 (linux) Cancel-Lock: sha1:pVnGw1MQeJisjlvbKhk2GtXtAdw= MIME-Version: 1.0 Content-Type: text/plain; charset=us-ascii Lines: 18 Organization: FINNET customers NNTP-Posting-Host: 213.139.166.59 X-Trace: 1330677679 news.fv.fi 3120 213.139.166.59:53569 X-Complaints-To: abuse@news.fv.fi Xref: csiph.com comp.databases.ms-sqlserver:935 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