#730: sqlite: troubles with datetime columns: unable to parse decltype: datetime ----------------------+----------------------------------------------------- Reporter: neteler | Owner: grass-dev@… Type: defect | Status: new Priority: normal | Milestone: 6.4.0 Component: Database | Version: 6.4.0 RCs Keywords: | Platform: All Cpu: All | ----------------------+-----------------------------------------------------
Comment(by mmetz): Replying to [ticket:730 neteler]: > There are some troubles with datetime columns in SQLite: > [snip] > > Not sure what to do: map to which DB_SQL_TYPE_xxx? > The SQLite documentation says that datetime is of the format "YYYY-MM-DD HH:MM:SS". According to lib/db/dbmi_base/datetime.c, DB_SQL_TYPE_TIMESTAMP seems to be an exact match. Try trunk r48359. Markus M -- Ticket URL: <https://trac.osgeo.org/grass/ticket/730#comment:1> GRASS GIS <http://grass.osgeo.org>
_______________________________________________ grass-dev mailing list grass-dev@lists.osgeo.org http://lists.osgeo.org/mailman/listinfo/grass-dev