These functions are only available when connected to an Aster database.
The Truncate To functions perform a truncate on the date/time stamp to the specified granularity. When dragging a Truncate To function into a variable, a tree element like the following is created.
Variable Creation > Input > Variables: SQL Elements pane - Date and Time > Truncate To Day
This example shows the Truncate To Day tree element. The following Truncate To functions share the same general structure.
| Function | Description |
|---|---|
| Truncate To Day | Truncates the date/time stamp to the day. |
| Truncate To Hour | Truncates the date/time stamp to the hour. |
| Truncate To Minute | Truncates the date/time stamp to the minute. |
| Truncate To Month | Truncates the date/time stamp to the month. |
| Truncate To Second | Truncates the date/time stamp to the second. |
| Truncate To Year | Truncates the date/time stamp to the year. |
| Truncate To Century | Truncates the date/time stamp to the century. |
| Truncate To Decade | Truncates the date/time stamp to the decade. |
| Truncate To Microseconds | Truncates the date/time stamp to the microsecond. |
| Truncate To Millennium | Truncates the date/time stamp to the millennium. |
| Truncate To Milliseconds | Truncates the date/time stamp to the millisecond. |
| Truncate To Quarter | Truncates the date/time stamp to the quarter. |
| Truncate To Week | Truncates the date/time stamp to the week. |