Correctly dealing with dates and time is critically important in data warehouses. In the end, you should understand that this is one of the most important attributes in a majority of fact tables in your DWH, which defines the "position" of your data records. Lots of reports are filtering data by date-time fields before performing data aggregation. This is probably why Data Services has a decent amount of date functions, allowing a variety of operations on date-time variables and table columns.
Data Services supports the following date data types:
timestamp. They define what part of time units are stored in the field:
date: This stores the calendar date
datetime: This stores the calendar date and the ...