handle timezone display, change date/time to datetime in DB