home bbs files messages ]

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