• Thanks all, I too was unaware of this data type but have now put it into use. I agree that DST is a pain. The timezones in .net know that they are DST affected but still return the time without this factored in. Nice. As I say, I stumbled across this and it saved me a whole heap of pain but Microsoft do need to handle the DST issue or else we will still have to code around this in some way.

    James
    MCM [@TheSQLPimp]