« first day (4345 days earlier)      last day (524 days later) » 

5:10 AM
That was golf though
 
 
13 hours later…
6:02 PM
Golf has always been great
 
This is hopeless dbfiddle.uk/MArD2bRI
 
haha Arithmetic overflow error for type varchar
@PaulWhite only fails for style 3?
 
6:21 PM
@ypercubeᵀᴹ Yes, the other styles use less precision. We're supposed to use 3 to ensure a round-trip representation
The max variant doesn't account for the space needed by the sign 😭
 
@PaulWhite but you can convert to varchar(8000) - or varchar(30) - and then to varchar(max)? weird
 
Yep, it's stupid
Also, the error message reports an inaccurate value
An imprecise value, I should say
The true representation being -999999.999999999883584678173065185546875
(closest double precision value)
 
eh, the diff is less than a satoshi coin ;)
your value has been taxed by 0.0000000000000116415321826934814453125%
 
6:51 PM
true
but this isn't helpful:
> Msg 232 Level 16 State 2 Line 3
Arithmetic overflow error for type varchar, value = -1000000.000000.
 
@PaulWhite fewer
2
 
@PaulWhite it's a catch-22 situation.
Spain - Germany is about to start
 
7:15 PM
They're always about to kick off those two
Good job France keeps them apart
I see Morocco beat Belgium
 
 
3 hours later…
10:28 PM
@ypercubeᵀᴹ that’s a good one
 

« first day (4345 days earlier)      last day (524 days later) »