t.list.rast where <=/>=

[martinl]

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

[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.

[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? :-)

[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?

[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 :)

[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.

[veroandreo]

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

[veroandreo]

Closing. Reopen if needed.