Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi all,
i have a Timekey in my main table which is set up for each seconds. i.e., the values will be from 1 to 86400.
Now, i have to join this table with another table that has timekey set up for each hour i.e., from 1 to 24.
How can i aggregate the Timekey in my main table to have values for each hour (1 to 24) so that i can join the two tables and have meaningful values. please help
You could try it with: hour(1 / 86400 * YourSecondField)
- Marcus