removed datetrunc queries