*!40000 ALTER TABLE `colors` DISABLE KEYS */ ) ENGINE =MyISAM AUTO_INCREMENT = 105 DEFAULT CHARSET =latin1 *!40000 ALTER TABLE `cdef_items` ENABLE KEYS */ *!40000 ALTER TABLE `cdef_items` DISABLE KEYS */ ) ENGINE =MyISAM AUTO_INCREMENT = 24 DEFAULT CHARSET =latin1 `value ` varchar( 150) NOT NULL DEFAULT ' ', `type ` tinyint( 2) NOT NULL DEFAULT '0 ', `sequence ` mediumint( 8) unsigned NOT NULL DEFAULT '0 ', `cdef_id ` mediumint( 8) unsigned NOT NULL DEFAULT '0 ', *!40000 ALTER TABLE `cdef` ENABLE KEYS */ *!40000 ALTER TABLE `cdef` DISABLE KEYS */ ) ENGINE =MyISAM AUTO_INCREMENT = 16 DEFAULT CHARSET =latin1 `name ` varchar( 255) NOT NULL DEFAULT ' ', `hash ` varchar( 32) NOT NULL DEFAULT ' ', `id ` mediumint( 8) unsigned NOT NULL AUTO_INCREMENT, *!40101 SET character_set_client = utf8 */ *!40101 SET SQL_MODE='NO_AUTO_VALUE_ON_ZERO' */ ĬREATE DATABASE /*!32312 IF NOT EXISTS */ `cacti ` /*!40100 DEFAULT CHARACTER SET latin1 */ INTERVAL '1 second' * round((extract('epoch' from earthnetworks_dt_horario) / 600) * 600) as horario,įROM raios.earthnetworks, raios.- MySQL dump 10.13 Distrib 5.5.43, for debian-linux-gnu (x86_64) I tried this and it did not work as expected. I tried date_trunc which does not have the precision I need.Įx: between 15:30:00, 15:40:00 5 results. I have all timestamps in between a period, but I need to group it every 10 minutes and I have no idea how. WHERE ST_Within(earthnetworks_geometry_raios, poligono_geometry) I have this query below that returns me a result set: SELECT timestamp I need to group by a period of time spliting up by 10 minutes.
0 Comments
Leave a Reply. |
AuthorWrite something about yourself. No need to be fancy, just an overview. ArchivesCategories |