truncate date when starting a new visit to remove millisecond components to fix mysql bug