Forum Discussion
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 getting the following error aobut only one timestamp and no gaps. What is wrong. (The original times were in Zulu UTC, so that is why they show as 8:00 PM, but I can fix that if needed).
day table
change the day column to date type, instead of datetime.
2 Replies
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.
