how to create a sequence of time?

Hi all,

I want to create a set of sequence of an hourly date and time starts from 2019,01,01 to 2019,12,31

then calculate the average of every 6 hours.

any help will be appreciated.

Answer 1

[Simon Chan]

How about the following?

It starts from 2019-01-01 00:00:00 to 2019-12-31 23:00:00 with 1 hour interval

datetime('2019-01-01')+hours(0:1:365*24-1)

First 4 output shown below:

 01-Jan-2019 00:00:00   01-Jan-2019 01:00:00   01-Jan-2019 02:00:00   01-Jan-2019 03:00:00

[Lilya]

Thank you! it works.

I am still struggling with the 6 hours average :)

[Simon Chan]

Check function movmean, it may help you

[Lilya]

thank you !!