Thanks for the additional info guys, I didn't know that the precision on a datetime as 3.33ms. I always just use a datetime column and pass in getdate(), so...

looks like stricknyn has the right idea. depending on how often one format shows up vs. the other, his approach may be about the fastest... saves the step of...