Post reply

how to implement the functiionality of SWITCHOFFSET in SQL server 2005?

  • July 1, 2008 at 3:30 am

    #189881

    Is there a way by which I can implement the SWITCHOFFSET of sql server 2008 in SQL 2005 itself.

    Any workaround or similar function would suffice my requirements.

    Any kind of help is very much appreciated

  • July 1, 2008 at 11:10 am

    #836831

    Sure. Build a table of time zones and their offset, and query against that. Pretty simple, actually. And can be used in joins for set-based calculations.

    - Gus "GSquared", RSVP, OODA, MAP, NMVP, FAQ, SAT, SQL, DNA, RNA, UOI, IOU, AM, PM, AD, BC, BCE, USA, UN, CF, ROFL, LOL, ETC
    Property of The Thread

    "Nobody knows the age of the human race, but everyone agrees it's old enough to know better." - Anon

Viewing 2 posts - 1 through 1 (of 1 total)

You must be logged in to reply to this topic. Login to reply