Using date functions
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 ...