n,
Rob
From: Michael Shishcu [mailto:mickl...@gmail.com]
Sent: 11 July 2011 16:19
To: Langford, Robert
Cc: gdal-dev@lists.osgeo.org
Subject: Re: [gdal-dev] ogr2ogr SQL Date Calculation
Hi Robert,
there is a Date command for windows commandline
http://ss64.com/nt/da
In PostgreSQL, you should be able to do something like:
> SELECT now() - INTERVAL '30 DAYS';
?column?
--
2011-06-11 08:34:03.32524-07
(1 row)
See table 9-26 on this page:
http://www.postgresql.org/docs/8.4/static/functions-datetime.html
for a w
Hi Robert,
there is a Date command for windows commandline
http://ss64.com/nt/date.html
hope this helps
regards,
michael
On Mon, Jul 11, 2011 at 6:11 PM, Langford, Robert <
robert.langf...@salford.gov.uk> wrote:
> All,
>
> I am trying to use ogr2ogr as a scheduled command line task to run wee
All,
I am trying to use ogr2ogr as a scheduled command line task to run weekly to
convert a .SHP file to a .TAB file whilst filtering the data based on a date
field. I would like to only convert records that have a date from the last 30
days.
Therefore If the task ran today (11/07/2011) the b
