Consider the following to outputs from the same query in ET:
select JobID, SubscriberKey, EventDate from _open with (nolock) where EventDate > '2013-04-30' and EventDate < '2013-10-31'
Outputs to a lot of lines of data, but I am curious about this:
31502339 2013-11-30 11:27:51 firstname.lastname@example.org 31502339 2013-11-30 11:27:51.020000000 email@example.com
Why do we need that much precision
Both lines are output from the same field and on the surface appear to be the same value. Any way to normalize it to the same format?