modified all opengeo to use date_trun funcion for measured_at to improve
performance