id summary reporter owner description type status priority milestone component version resolution keywords cc cpu platform 1517 'DateTime' not handled by v.in.ogr grasslandtom grass-dev@… "steps to reproduce: _ create a table in PostGIS-database 'test': {{{ create table test (id INT, datetime TIMESTAMP); SELECT addgeometrycolumn('test', 'the_geom', 4030, 'POINT', 2); insert into test values (1, '2001-01-01 00:12:00', st_setsrid(ST_point(12, 50), 4030)); }}} _ import in GRASS: {{{ v.in.ogr dsn='PG:dbname=test' out=test layer='test(the_geom)' location=new_test }}} This raises the error {{{ DBMI-DBF driver error: SQL parser error: syntax error, unexpected NAME processing 'datetime' in statement: create table test (cat integer, datetime datetime, id integer) Error in db_execute_immediate() }}} When the location is connected to PostGIS: _ import in GRASS {{{ v.in.ogr -o dsn='PG:dbname=test' out=test_out layer='test(the_geom)' }}} raises the error {{{ DBMI-Postgres driver error: Cannot execute: create table test_out (cat integer, datetime datetime, id integer) FEHLER: Typ »datetime« existiert nicht LINE 1: create table test_out (cat integer, datetime datetime, id in... ^ }}} (Sorry for the German error message. This one seems to come from the PostgreSQL Server which was running before I set the respective environment variables) When the location is connected to SQLite, the import works without a warning respective to DateTime but {{{ db.columns test_out }}} raises {{{ WARNING: SQLite driver: unable to parse decltype: datetime WARNING: SQLite driver: unable to parse decltype: datetime WARNING: SQLite driver: column 'datetime', SQLite type 3 is not supported cat id }}} Note that {{{ ogrinfo 'PG:dbname=test' 'test(the_geom)' }}} gives in the last lines {{{ datetime: DateTime (0.0) id: Integer (0.0) OGRFeature(test(the_geom)):0 datetime (DateTime) = 2001/01/01 0:12:00 id (Integer) = 1 POINT (12 50) }}} Thus, DateTime seems to exist in OGR. Though the SQL data type is TIMESTAMP." defect reopened normal 6.4.6 Database 6.4.2 RCs v.in.ogr, DateTime, TIMESTAMP Unspecified Unspecified