Click here to monitor SSC
SQLServerCentral is supported by Red Gate Software Ltd.
 
Log in  ::  Register  ::  Not logged in
 
 
 
        
Home       Members    Calendar    Who's On


Add to briefcase ««123»»

DateTime Functions Expand / Collapse
Author
Message
Posted Thursday, April 5, 2012 8:24 AM


Ten Centuries

Ten CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen CenturiesTen Centuries

Group: General Forum Members
Last Login: Thursday, January 31, 2013 8:53 AM
Points: 1,176, Visits: 778
good question - cheers
Post #1278859
Posted Thursday, April 5, 2012 8:37 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 7, 2014 4:29 AM
Points: 103, Visits: 30
learn something new today

Post #1278872
Posted Thursday, April 5, 2012 8:56 AM
Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Yesterday @ 4:13 PM
Points: 3,786, Visits: 1,083
Good question, Steve. I like this kind of questions where I have to read and learn new things.

"El" Jerry.


"El" Jerry.

"A watt of Ottawa" - Gerardo Galvan
Post #1278898
Posted Thursday, April 5, 2012 9:16 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: Monday, July 21, 2014 8:35 AM
Points: 3,642, Visits: 72,429
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... :)




--Mark Tassin
MCITP - SQL Server DBA
Proud member of the Anti-RBAR alliance.
For help with Performance click this link
For tips on how to post your problems
Post #1278921
Posted Thursday, April 5, 2012 9:18 AM


SSC-Dedicated

SSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-DedicatedSSC-Dedicated

Group: Administrators
Last Login: Yesterday @ 5:30 PM
Points: 33,055, Visits: 15,167
Glad you liked this one. It was one that taught me something when I wrote it.






Follow me on Twitter: @way0utwest

Forum Etiquette: How to post data/code on a forum to get the best help
Post #1278924
Posted Thursday, April 5, 2012 10:04 AM


Hall of Fame

Hall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of FameHall of Fame

Group: General Forum Members
Last Login: 2 days ago @ 6:57 PM
Points: 3,258, Visits: 1,954
Nice question Steve, learned something new today.
Post #1278977
Posted Thursday, April 5, 2012 2:30 PM


SSCrazy Eights

SSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy EightsSSCrazy Eights

Group: General Forum Members
Last Login: Yesterday @ 10:00 AM
Points: 8,551, Visits: 9,043
mtassin (4/5/2012)
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... :)

+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.


Tom
Post #1279165
Posted Friday, April 6, 2012 7:46 AM
SSC-Enthusiastic

SSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-EnthusiasticSSC-Enthusiastic

Group: General Forum Members
Last Login: Monday, April 7, 2014 2:47 PM
Points: 134, Visits: 186
Something 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.



Post #1279491
Posted Sunday, April 8, 2012 11:23 AM
SSCommitted

SSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommittedSSCommitted

Group: General Forum Members
Last Login: Sunday, April 27, 2014 7:45 PM
Points: 1,589, Visits: 253
Good straightforward question. Thanks for submitting.

http://brittcluff.blogspot.com/
Post #1279988
Posted Monday, April 9, 2012 8:31 AM
SSC Veteran

SSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC VeteranSSC Veteran

Group: General Forum Members
Last Login: Tuesday, June 3, 2014 8:57 AM
Points: 228, Visits: 236
Good 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.

Chris Umbaugh
Data Warehouse / Business Intelligence Consultant
twitter @ToledoSQL
Post #1280168
« Prev Topic | Next Topic »

Add to briefcase ««123»»

Permissions Expand / Collapse