These SQL functions might come in handy for your ETL and DWH.
I’m currently designing a DWH which will have three ‘TimeDimensions’:
– DateDimension (grain = day)
– TimeDimension (grain = second)
– TimeZoneDimension (grain = offset in minutes)
Simply said, these functions convert a DATETIMEOFFSET value into three types of integer identity values (which can be used in your dimensions).
Want it? 🙂
Download it here:
DateTimeOffset to Date Time Offset Identities – SQL Code