change datetime and date to 'text'
note that local DB supports these datatypes, but the format that mysql gives is actually text and it is necessary to treat them as such.