# List of date functions

Available in...

* Cloud API Services Platform
* Cloud Big Data
* Cloud Big Data Platform
* Cloud Data Fabric
* Cloud Data Integration
* Cloud Data Management Platform
* Cloud Pipeline Designer Standard Edition
* Data Fabric

Date functionsDate functions

| Name | Description |
| --- | --- |
| Calculate timestamp to date | Given a timestamp (ellapsed time in<br>second since Unix time, that is to say 01/01/1970), create a new column with the<br>date |
| Calculate time since | Calculates elapsed time since a date in the<br>desired unit (year, month, day, hour, minute, second) |
| Compare dates | Compares this column to another column or a<br>constant |
| Convert dates | Converts dates from one calendar to<br>another |
| Extract date parts | Creates columns with year, month, quarter, day,<br>hour, minute, second, etc. |
| Modify dates | Adds or substract time unit amount |