Master calendar

[Anonymous]

Hi,

I am looking to add to the standard Master Calendar code, additional granularity of 1 - 24 hours in a day.

Not so sure how to code it.

Thanks

[Gysbert_Wassenaar]

Perhaps you should create a Master Time table instead: The Master Time Table‌. Otherwise you'll increase the size of your Master Calendar table by a factor of 24.

[maxgro]

d: load rowno() as id, date(makedate(2015) + rowno()-1) as d AutoGenerate 365;

left join (d) load (rowno()-1)/24 as h AutoGenerate 24;

d2: load Timestamp(d + h) as dh Resident d;

DROP Table d;