Forum Discussion
Solved
Mark as date table (bogus error?)
I have tripled checked the "day" column in this table. Each value is unique and there are no gaps (I do this with external ETL tools in Planatir Foundry where I generate the table). But I am still...
change the day column to date type, instead of datetime.
That works. The reason that I did it with a timestamp is that I will want the table to soon change to hour/day/month/year. I did not see if it is possible to still flag this as a date table, and also how to organize this so that one can drill-down timecharts.
The training classes I saw all used timestamps with the start of (day, week, month. But the date hierachies are really messy if one has a timestamp.