Returns true if X matches the regular expression pattern, otherwise returns false. Returns first matching substring in X which matches the regular expression pattern. Returns true if X contains the regular expression pattern, otherwise returns false. The number of characters is specified by length. Returns a number of characters from the beginning of X. Returns true if X ends with text, otherwise returns false. Returns true if X contains text, otherwise returns false. Returns a text that is the concatenation of X and Y. The expression cannot include any aggregations. Returns the result of a SQL expression as evaluated by the underlying dataset. Returns a hyperlink to the URL, labeled with the link label. Aggregated fields are not allowed inside CAST. Returns the year and week number of a given date.Ĭast field or expression into TYPE. Returns a number representing the day of the week for a given date. Returns the week number for a given date. Returns a formatted compatibility mode Date. Returns the seconds component of a given date and time. Returns the quarter of the year for a given date. Returns the month from a Date & Time value. Returns the minutes component of a given date and time. Returns the day of a Date or Date & Time.įORMAT_DATETIME(format_string, datetime_expression) Truncates a date to the specified granularity. Subtracts a specified time interval from a date.ĭATETIME_SUB(datetime_expression, INTERVAL integer part) Returns the number of part boundaries between two dates.ĭATETIME_DIFF(date_expression, date_expression, part) Ĭonstructs a Date & Time field or value from numbers.ĭATETIME(year, month, day, hour, minute, second)Īdds a specified time interval to a date.ĭATETIME_ADD(datetime_expression, INTERVAL integer part) Interprets an integer as the number of days since.

Returns the difference in days between X and Y (X - Y). Returns the current date and time as of the specified or default timezone.Ĭonstructs a Date field or value from numbers or from a Date & Time field or expression. Returns the current date as of the specified or default timezone. NULLIF(input_expression, expression_to_match) Returns null if the input matches an expression, otherwise returns the input. true_result is not evaluated if condition is false or NULL. false_result is not evaluated if condition is true. If condition is true, returns true_result, else returns false_result. Returns a result if the input is null, otherwise, returns the input. Returns the first non-missing value found in a list of fields.ĬOALESCE(field_expression) Learn moreĬompares input_expression to expression_to_match of each successive WHEN clause and returns the first result where this comparison returns true. If all conditions are false or NULL, returns else_result if present if not present, returns NULL. Note that X must be non-negative.Įvaluates the condition of each successive WHEN clause and returns the first result where the condition is true any remaining WHEN and ELSE clauses are not evaluated. Returns result of raising X to the power Y. At least one input argument must be a field or an expression containing a field. All input arguments must be of the same type, all numbers. All input arguments must be of the same type: all numbers. For example, if the value X is v, FLOOR(X) is equal to or less than v.

For example, if the value of X is v, CEIL(X) is greater than or equal to v. Returns the nearest integer greater than X. Returns the percentile rank N of field X. Returns the number of unique values of X.

Looker calculations subtract dates