updated validation in events controller and date time in sql service