Dates

Manipulating dates

---

Data Warehouse: Create Date Dimension (version 1)

5 Feb, 2015  in root  tagged Data Warehouse / Dates / ETL / T-SQL by Peter Lalovsky

Data Warehouse is “a system used for reporting and data analysis”. In general it is built by dim (dimension) and fact tables (structure and data tables). Here I create a stored procedure to build Date Dimension. Now it builds only calendar data and will be expanded to include “fiscal” data […]

---

T-SQL: udf_DurationHourMinSec() – Duration between start date and end date

13 Jan, 2015  in T-SQL  tagged Dates / T-SQL / User Defined Function by Peter Lalovsky

I built a function for reporting purposes that shows the duration in hh:mm:ss between two datetime columns. It can be used in a reporting tool to show the data in a log. The max difference in DATEDIFF() is 68 years. Quick and extended calculation (every year is a leap year): 68 years […]

---