Q&A for scientific skepticism
SELECT * FROM Users WHERE [CreationDate] > DATEADD(MILLISECOND, -1, '2010-06-01') AND [CreationDate] < DATEADD(DAY, 1, '2010-06-01')