[GRASS-dev] datetime function in v.in.ogr

[Paulo van Breugel]

Op 27 juni 2019 23:05:17 schreef Markus Metz <markus.metz.giswork at gmail.com>:
>
>
> On Thu, Jun 27, 2019 at 9:27 PM Paulo van Breugel <p.vanbreugel at gmail.com> 
> wrote:
>>
>> Hi devs,
>>
>> I am trying to import a shapefile using v.in.ogr, filtering on date
>> using datetime, e.g.,
>>
>> v.in.ogr input=myshapefile.shp layer=myshapefile output=outputlayer
>> where="datm_start >= datetime('2019-01-01')"
>>
>> I am getting the message:
>>
>> ERROR 1: Undefined function 'datetime' used.
>> ERROR: Error setting attribute filter 'datm_start >= datetime('2019-01-01')'
>>
>> Does this mean it is not possible to use functions in v.in.ogr? Or am I
>> doing somthing wrong?
>
>
>
> The OGR shapefile driver does not support this function. You need to import 
> the shapefile into GRASS, using anything but the dbf driver as database 
> driver (default is sqlite), then try to filter with v.extract 
> where="datm_start >= datetime('2019-01-01')"

Ok, thanks, was hoping I could do a selection before to safe on the time ik 
takes to import. I'll look for a way to filter before import using another 
tool.


>
>
> HTH,
>
>
> Markus M
>
>
>>
>> Running grass gis 7.6, Linux.
>>
>>
>> Cheers,
>>
>> Paulo
>>
>>
>> _______________________________________________
>> grass-dev mailing list
>> grass-dev at lists.osgeo.org
>> https://lists.osgeo.org/mailman/listinfo/grass-dev

-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.osgeo.org/pipermail/grass-dev/attachments/20190627/ff1f0c5d/attachment.html>