Martin,
Yes; I pretty much figured that out -- 'datetime' worked. I'm slowly
catching on...
Tom
On Fri, Jan 20, 2017 at 7:18 AM, Martin Landa
wrote:
> Hi,
>
> 2017-01-20 13:15 GMT+01:00 Thomas Adams :
> > Thank you; I did try 'date' and got the same
Hi,
2017-01-20 13:15 GMT+01:00 Thomas Adams :
> Thank you; I did try 'date' and got the same result using the exact dataset.
well, 'date' is also SQL reserved word :-) [1] Ma
[1] http://developer.mimer.se/validator/sql-reserved-words.tml
--
Martin Landa
Helmut,
Thank you; I did try 'date' and got the same result using the exact
dataset. After sending out the email (thinking GRASS *might* be choking on
the number of columns), I reduced the number of columns and re-ordered them
(thinking that maybe the ID ought to come first -- also recognizing
>SQL parser error (syntax error, unexpected TIME, expecting
>NAME processing 'time') in statement:
Could it be that time is a SQL reserved word/key? Try another word instead
of 'time'.
HTH
Helmut
-
best regards
Helmut
--
View this message in context: