Raghavendra Mudugal (3/18/2013)
Awesome Qtod,thank you for posting.(I am bursting with my doubts... but no idea where to begin...)
so to say... there will be no row/s in the datetime column where it ends with other than these .000, .003 or .007. Like .004 turns to .003 or .129 turns in to .127.... ? .002 changes to .003?
My main doubt is... in the BOL it says under property as "accuracy" and then the corresponding value starts with " rounded to increment..." ? what type of accuracy is this? :crazy:
edit; fixed the "property" spell
😀 I found this out while migrating data on a datetime, that too from sybase datetime (i think it's 3 6 9 in millisecond for sybase datetime) , had to convert it to datetime2 for exactness..
yes, it is mentioned in bol ..the accuracy and the behaviour and cost fo this accuracy ...
so use as you wish .. and ignore as you wish ..
~ demonfox
___________________________________________________________________
Wondering what I would do next , when I am done with this one :ermm: