• 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