DATE AND TIME Functions
All functions > DATE AND TIME
All functions in the DATE AND TIME category.
Arithmetic Date
| Function | Description |
|---|
ADD | Returns the date/timestamp after adding a given interval to the given date/timestamp. |
SUBTRACT | Returns difference between two dates or date and interval. |
DATE_ADD | Returns the date/timestamp after adding a given number of a given units to the given date/timestamp. |
DATE_DIFF | Returns the difference between the two given timestamps in the given unit. |
Extraction Date
| Function | Description |
|---|
EXTRACT_FROM_DATE | Returns the part of the given timestamp in the given unit. |
Formatting Date
| Function | Description |
|---|
DATE_TRUNC | Returns the given timestamp truncated to the given unit. |
DATE_FORMAT | Returns a string from the given timestamp and format. |
TO_ISO8601 | Returns an ISO 8601 string from the given timestamp. |
Parsing Date
Conversion Date
| Function | Description |
|---|
FROM_UNIXTIME | Returns a timestamp from the given unix timestamp (BIGINT representation of the number of seconds... |
TO_UNIXTIME | Returns a unix timestamp (BIGINT representation of the number of seconds since 1970-01-01 00:00:00... |
Duration
| Function | Description |
|---|
HUMAN_READABLE_SECONDS | Returns a human readable string from the given number of seconds. |
PARSE_DURATION | Returns an interval from the given duration string. |
TO_MILLISECONDS | Returns the truncated number of milliseconds in the given interval. |
Summary
- Functions in DATE AND TIME: 15
This documentation is automatically generated from the FeatureMesh registry.