Forums before death by AOL, social media and spammers... "We can't have nice things"
|    comp.databases.ms-sqlserver    |    Notorious Rube Goldberg contraption    |    19,505 messages    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
|    Message 18,568 of 19,505    |
|    Antti =?us-ascii?Q?J=3D=3Fiso-8859- to All    |
|    Datetime with timezone information in it    |
|    02 Mar 12 10:41:18    |
      From: costello@iki.fi              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              --- SoupGate-Win32 v1.05        * Origin: you cannot sedate... all the things you hate (1:229/2)    |
[   << oldest   |   < older   |   list   |   newer >   |   newest >>   ]
(c) 1994, bbs@darkrealms.ca