Opened 6 years ago

Closed 21 months 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 Changed 6 years ago by 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.

comment:2 in reply to:  1 ; Changed 6 years ago by 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? :-)

comment:3 in reply to:  2 Changed 4 years ago by lucadelu

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 Changed 4 years ago by veroandreo

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 Changed 4 years ago by veroandreo

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 Changed 4 years ago by martinl

Milestone: 7.0.07.0.5

comment:7 Changed 3 years ago by neteler

Milestone: 7.0.57.0.6

comment:8 Changed 22 months ago by neteler

Milestone: 7.0.67.0.7

comment:9 Changed 21 months ago by veroandreo

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

comment:10 Changed 21 months ago by veroandreo

Resolution: invalid
Status: newclosed

Closing. Reopen if needed.

Note: See TracTickets for help on using tickets.