Master calendar with Time values

[#1]

Im using the master calendar created using the data form the code below. Id like to change this so that i can use time values in my master calendar. Any suggestions?:

//Temp Calendar
TempCalendar:
LOAD
$(varMinDate)+rowno() -1 AS DateNumber,
date($(varMinDate)+ rowno() -1 )AS TempDate,
AUTOGENERATE
$(varMaxDate)-$(varMinDate)+1;

[fernandotoledo · Accepted solution]

Use TIMESTAMP(DATE,'DD/MM/YYYY hh:mm:ss') instead DATE()

[#3]

Thankyou.