|
CREATE TABLE ts (tsCol SqlTimeSpan)
INSERT ts VALUES (SqlTimeSpan::FromTicks(-9223372036854775808))
,(SqlTimeSpan::FromTicks(-9223372036854775807))
,(SqlTimeSpan::FromTicks(-9223372036854775806))
,(SqlTimeSpan::FromTicks(-3))
,(SqlTimeSpan::FromTicks(-2))
,(SqlTimeSpan::FromTicks(-1))
,(SqlTimeSpan::FromTicks(0))
,(SqlTimeSpan::FromTicks(1))
,(SqlTimeSpan::FromTicks(2))
,(SqlTimeSpan::FromTicks(3))
,(SqlTimeSpan::FromTicks(9223372036854775805))
,(SqlTimeSpan::FromTicks(9223372036854775806))
,(SqlTimeSpan::FromTicks(9223372036854775807))
SELECT tsCol "tsCol stored bytes", tsCol.Ticks "tsCol.Ticks",
tsCol.ToString() "tsCol.ToString()" FROM ts ORDER BY tsCol
DROP TABLE ts
|
By viewing downloads associated with this article you agree to the Terms of Service and the article's licence.
If a file you wish to view isn't highlighted, and is a text file (not binary), please
let us know and we'll add colourisation support for it.
Gio has been writing programs for almost 10 years. Sometime on 2005, he decided to cut his hair and remove his nail polish so he could enter a commercial building in downtown Manila and submit his resume. That bold action eventually led him to the city by the bay in the sunshine state. He really like it there because he's still able to experience hurricanes which makes him very nostalgic albeit disappointed because it doesn't automatically translate to work suspension. If he's not outside watching squirrels play, he explores esoteric topics using .NET and SQL Server. And like squirrels, Gio is a very docile yet hardworking creature. If ever you see faults in his work, be gentle with the criticisms. He greatly appreciates this and rest assured your advice would be embodied in his future works.