Date function returns incomplete data

SQL++
1

to the reader a kind hello

not sure if this the place to post it

SELECT RAW DATE_RANGE_STR(‘2000-01-01T00:00:00Z’, ‘2000-01-01T23:59:59’, ‘minute’, 10)

output ends at 10 pm
(tested other end values as well)

thanks in advance

2

Start time is UTC, end time is local time. It depends on where is your server, local time is converted to UTC. Use both UTC or local time and it will give expected results.

SELECT RAW 
DATE_RANGE_STR("2000-01-01T00:00:00Z", "2000-01-01T23:59:59Z", "minute", 10);