Nice article.

Are there any new format options that go along with the new data types?

So when we currently say Convert(varchar,DATETIME,112) are there new options for

Convert(varchar,TIME,xxx)? I'm sure there must be a nice way of trimming the nonoseconds if you don't want them on the output.

Thanks,

Dan