DATE AND TIME Functions
All functions > DATE AND TIME
All functions in the DATE AND TIME category.
| Function | Description |
|---|---|
CURRENT_TIMESTAMP | [Non-deterministic] Returns the current date and time. |
DATE_ADD | Returns the date after adding the given value to the given timestamp. |
DATE_DIFF | Returns the difference between the two given timestamps in the given unit. |
DATE_FORMAT | Returns a string from the given timestamp and format. |
DATE_PARSE | Returns a timestamp from the given string and format. |
DATE_TRUNC | Returns the given timestamp truncated to the given unit. |
EXTRACT_FROM_DATE | Returns the part of the given timestamp in the given unit. |
FROM_ISO8601_TIMESTAMP | Returns a timestamp from the given ISO 8601 string. |
FROM_UNIXTIME | Returns a timestamp from the given unix timestamp (BIGINT representation of the number of seconds... |
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_ISO8601 | Returns an ISO 8601 string from the given timestamp. |
TO_MILLISECONDS | Returns the truncated number of milliseconds in the given interval. |
TO_UNIXTIME | Returns a unix timestamp (BIGINT representation of the number of seconds since 1970-01-01 00:00:00... |
Summary
- Functions in DATE AND TIME: 14
This documentation is automatically generated from the FeatureMesh registry.