Forum Discussion
Relation ruins visuals
Hello, I'm attempting to establish a connection between energy data and weather data tables. Both of the columns I'm attempting to link are formatted as "Long date." However, when I create the r...
The "Long Date" is only an ornament of the value. What really counts is the data type, like "date" and "datetime".
Here's the kicker: Internally there is no such thing as a "date". Everything is datetime, but the "date" values are pegged at 00:00:00am time.
Most likely you have data that goes down to time granularity on one table and "midnight" on the other table. When you join these tables the results will only include the columns that are actually at midnight.
Thank you for your response. The data type for both tables has been determined as "Date" ?