Opened 10 years ago

Closed 6 years ago

#2270 closed defect (invalid)

t.list.rast where <=/>=

Reported by: martinl Owned by: grass-dev@…
Priority: normal Milestone: 7.0.7
Component: Temporal Version: unspecified
Keywords: t.list.rast, where Cc:
CPU: Unspecified Platform: Unspecified

Description

I would assume that

t.rast.list modis where="start_time > '2002-03-01' and start_time <= '2002-05-31'" | tail -n1

print maps also including 31/5, but it's not true - the result is same as for

where="start_time > '2002-03-01' and start_time < '2002-05-31'"
terra_lst_night20020530 modis2002lst_yfsg       2002-05-30 22:30:00     None

Change History (10)

comment:1 by huhabla, 10 years ago

This is the magic of sqlite and postgresql regarding dates that are defined without time. This is not related to the implementation of TGRASS but to the chosen backend database.

in reply to:  1 ; comment:2 by martinl, 10 years ago

Replying to huhabla:

This is the magic of sqlite and postgresql regarding dates that are defined without time. This is not related to the implementation of TGRASS but to the chosen backend database.

Ah, so maybe big note about that in the manual? :-)

in reply to:  2 comment:3 by lucadelu, 8 years ago

Replying to martinl:

Replying to huhabla:

This is the magic of sqlite and postgresql regarding dates that are defined without time. This is not related to the implementation of TGRASS but to the chosen backend database.

Ah, so maybe big note about that in the manual? :-)

Yes, but where? the where option is in most of temporal commands. Do we should replicate this info everywhere or just in a place?

comment:4 by veroandreo, 8 years ago

I would add this here: https://grasswiki.osgeo.org/wiki/Temporal_data_processing#FAQ for a start. Just to have it somewhere. Or maybe a new section there?? Suggestions for new section name are welcome :)

comment:5 by veroandreo, 8 years ago

So, I added an example of this issue in the Temporal Data Processing Wiki, under FAQ section with the title "Use of where parameter" https://grasswiki.osgeo.org/wiki/Temporal_data_processing#Use_of_where_parameter_.28from_ticket_.232270.29. Please, feel free to modify that (or anything in that wiki), remove or add more details.

comment:6 by martinl, 8 years ago

Milestone: 7.0.07.0.5

comment:7 by neteler, 7 years ago

Milestone: 7.0.57.0.6

comment:8 by neteler, 6 years ago

Milestone: 7.0.67.0.7

comment:9 by veroandreo, 6 years ago

Ping! Shall we close this as won't fix?

comment:10 by veroandreo, 6 years ago

Resolution: invalid
Status: newclosed

Closing. Reopen if needed.

Note: See TracTickets for help on using tickets.