[GRASS-dev] [GRASS GIS] #730: sqlite: troubles with datetime columns: unable to parse decltype: datetime

[GRASS GIS]

#730: sqlite: troubles with datetime columns: unable to parse decltype: datetime
-----------------------+----------------------------------------------------
  Reporter:  neteler   |       Owner:  grass-dev@…              
      Type:  defect    |      Status:  closed                   
  Priority:  normal    |   Milestone:  6.4.0                    
 Component:  Database  |     Version:  6.4.0 RCs                
Resolution:  fixed     |    Keywords:  SQLite, datetime         
  Platform:  All       |         Cpu:  All                      
-----------------------+----------------------------------------------------
Changes (by neteler):

  * status:  new => closed
  * resolution:  => fixed


Comment:

 Works (testing with same file as reported 4 years ago):

 {{{

 GRASS 6.4.3svn (patUTM32):~ > db.select meteo_iasma_hourly_modis_overpass
 cat|station|data|t_max|t_min|t_mean
 1|st14|2001-11-01 10:00:00|8.3|7.1|7.7
 2|st14|2001-11-01 11:00:00|9.5|7.7|9.4
 3|st14|2003-04-11 01:00:00|-1.8|-2.5|-2.2
 ...

 GRASS 6.4.3svn (patUTM32):~ > db.connect -p
 driver:sqlite
 database:$GISDBASE/$LOCATION_NAME/$MAPSET/sqlite.db
 schema:
 group:
 }}}

 Closing.

-- 
Ticket URL: <https://trac.osgeo.org/grass/ticket/730#comment:3>
GRASS GIS <http://grass.osgeo.org>