InstantForum.NET v2.9.0SQLServerCentralhttp://www.sqlservercentral.com/Forums/notifications@sqlservercentral.comSun, 19 May 2013 16:48:35 GMT20http://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxNice one..Wed, 09 Jan 2013 06:36:29 GMTDineshbabuhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxnice question..learn something new today!!:-)Tue, 09 Oct 2012 01:40:34 GMTkapil_kkhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxThank you for the learning opportunity with the topic.Wed, 11 Apr 2012 08:24:11 GMTzymoshttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxGood question. Never used this data type before but I have a project coming my way soon where I may be able to leverage datetimeoffset. Very "timely" har har. Thanks.Mon, 09 Apr 2012 08:31:07 GMTChris Umbaughhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxGood straightforward question. Thanks for submitting.Sun, 08 Apr 2012 11:23:37 GMTBritt Cluffhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxSomething seems contradictory in the answer to this question. First it says the answer is 2012/04/05 11:00:00 +05:00. Then in the explanation it says the GMT time of the result is 2012/04/05 11:00 (in other words, the answer is 2012/04/05 11:00 +00.00).Well those two times are 5 hours apart, so they both can't be right.Fri, 06 Apr 2012 07:46:13 GMTwodomhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspx[quote][b]mtassin (4/5/2012)[/b][hr]Thanks for an easy one.I personally love this data type... it makes dealing with multi-time zone data a little bit easier.... datetime data still gives me more headaches than any other."Ok Ms. Smith we'll schedule a callback at 3pm your time in California on Friday"Ok so she's in a portion of California that doens't follow DST, we're in Chicago and we do.Is Friday in or out of DST? Do we know her correct TZ? What about when our east coast support team decides to handle this one? *sigh*Headaches I tell you... :)[/quote]+1 on that. I wish I'd had this data type and this function years back. We had customers in 4 time zones raging from +05:30 to -06:00.Thu, 05 Apr 2012 14:30:53 GMTL' Eomot Inverséhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxNice question Steve, learned something new today.Thu, 05 Apr 2012 10:04:47 GMTKWymorehttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxGlad you liked this one. It was one that taught me something when I wrote it.Thu, 05 Apr 2012 09:18:24 GMTSteve Jones - SSC Editorhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxThanks for an easy one.I personally love this data type... it makes dealing with multi-time zone data a little bit easier.... datetime data still gives me more headaches than any other."Ok Ms. Smith we'll schedule a callback at 3pm your time in California on Friday"Ok so she's in a portion of California that doens't follow DST, we're in Chicago and we do.Is Friday in or out of DST? Do we know her correct TZ? What about when our east coast support team decides to handle this one? *sigh*Headaches I tell you... :)Thu, 05 Apr 2012 09:16:26 GMTmtassinhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxGood question, Steve. I like this kind of questions where I have to read and learn new things."El" Jerry.Thu, 05 Apr 2012 08:56:54 GMTEL Jerryhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxlearn something new today :-)Thu, 05 Apr 2012 08:37:46 GMTyannick.dingerhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxgood question - cheersThu, 05 Apr 2012 08:24:41 GMTOzYbOi d(-_-)bhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxHad to read a bit to figure it out, learned something. Thanks.Thu, 05 Apr 2012 07:28:25 GMTDaniel Bowlinhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxThanks Steve! We currently code for locations in one time zone, so we don't use these types of things much. However, we recently became part of a global enterprise and will have to start doing so. Time zone considerations and collation considerations will finally become important to us, and not just as QOTD's.Thu, 05 Apr 2012 05:28:16 GMTThomas Abrahamhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxNice Question!Thu, 05 Apr 2012 04:55:41 GMTCoolCodeSharehttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxGood question!Thanks.:-PThu, 05 Apr 2012 02:37:27 GMTCarlo Romagnanohttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxGreat question, thanks. I never use this datatype though.Wed, 04 Apr 2012 23:18:08 GMTKoen Verbeeckhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxNice question, Thank-you, Steve! Learnt something new.Wed, 04 Apr 2012 22:59:10 GMTNakul Vachhrajanihttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxDefinately a good question.Wed, 04 Apr 2012 21:41:40 GMTLynn Pettishttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxI like it - keep em coming.Wed, 04 Apr 2012 21:35:08 GMTSQLRNNRhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxNice !!!. Good to learn knew stuff !!!!.Wed, 04 Apr 2012 20:26:03 GMTbaabhuhttp://www.sqlservercentral.com/Forums/Topic1278522-32-1.aspxComments posted to this topic are about the item [B]<A HREF="/questions/T-SQL/89253/">DateTime Functions</A>[/B]Wed, 04 Apr 2012 20:17:08 GMTSteve Jones - SSC Editor