ensures date columns are formatted with micro seconds removed. Unit test...

...ing to ensure code works as according