Equivalent Functions & Operators

e6data

Athena

current_date()

current_date

current_date(timezone)

current_date AT TIME ZONE timezone

current_timestamp()

current_timestamp

current_timestamp(timezone)

current_timestamp AT TIME ZONE timezone

last_day( <date/datetime expr> )

date_trunc('month', date) + interval '1' month - interval '1' day

date_trunc(unit, <expr> )

DATE_TRUNC('unit', timestamp)

date_add(unit, value, <date expr>)

date_add(unit, value, timestamp)

date_diff( <date expr1>, <date expr2>, [<unit> optional])

date_diff(unit, timestamp1, timestamp2)

timestamp_add(unit, value, <timestamp expr>)

date_add(unit, value, timestamp)

timestamp_diff(<timestamp expr1>, <timestamp expr2>, unit)

date_diff(unit, timestamp1, timestamp2)

to_timestamp( <expr> )

to_timestamp(string, format)

datetime(<expr>, <time zone>)

from_unixtime(<expr>, [<unit> optional])

from_unixtime(unixtime)

to_unix_timestamp( <expr> )

to_unixtime(expr)

format_date( <expr>, format)

format_datetime(timestamp, format)

format_timestamp(<expr>, format)

format_datetime(timestamp, format)

extract( unit FROM <datetime expr>)

extract(field FROM x)

current_timestamp + interval '8' minute

timestamp '2012-10-31 01:00' + interval '1' month

array_to_string( <expr>, delimiter)

array_join(x, delimiter, null_replacement)

json_value( <json expr>, <json-path>)

json_extract_scalar(json, json_path)

e6data

BigQuery

approx_quantiles( <expr>, number)

APPROX_QUANTILES( expression, number)

current_date()

current_date(timezone)

CURRENT_DATE([time_zone])

current_timestamp()

CURRENT_TIMESTAMP()

current_timestamp(timezone)

DATETIME(CURRENT_TIMESTAMP(), "America/Los_Angeles")

last_day( <date/datetime expr> )

date_trunc(unit, <expr> )

DATE_TRUNC(date_expression, unit)

date_add(unit, value, <date expr>)

DATE_ADD(date_expression, INTERVAL int64_expression date_part)

date_diff( <date expr1>, <date expr2>, [<unit> optional])

DATE_DIFF(date_expression_a, date_expression_b, date_part)

timestamp_add(unit, value, <timestamp expr>)

DATETIME_ADD(datetime_expression, INTERVAL int64_expression part)

timestamp_diff(<timestamp expr1>, <timestamp expr2>, unit)

DATETIME_DIFF(datetime_expression_a, datetime_expression_b, part)

to_timestamp( <expr> )

TIMESTAMP(string_expression[, time_zone])

datetime(<expr>, <time zone>)

DATETIME(timestamp_expression [, time_zone])

from_unixtime(<expr>, [<unit> optional])

format_timestamp("%Y-%m-%d", timestamp_seconds(time))

to_unix_timestamp( <expr> )

UNIX_SECONDS(expr)

format_date( <expr>, format)

FORMAT_DATE(format_string, date_expr)

format_timestamp(<expr>, format)

FORMAT_DATETIME(format_string, datetime_expression)

extract( unit FROM <datetime expr>)

EXTRACT(part FROM date_expression)

current_timestamp + interval '8' minute

array_to_string( <expr>, delimiter)

ARRAY_TO_STRING(array_expression, delimiter[, null_text])

json_value( <json expr>, <json-path>)

JSON_VALUE(json_expr[, json_path])

e6data

Databricks

current_date()

current_date(timezone)

from_utc_timestamp(current_date(),timezone)

current_timestamp()

current_timestamp(timezone)

from_utc_timestamp(current_timestamp(),timezone)

last_day( <date/datetime expr> )

last_day(expr)

date_trunc(unit, <expr> )

date_trunc(unit, expr)

date_add(unit, value, <date expr>)

dateadd(unit, value, expr)

date_diff( <date expr1>, <date expr2>, [<unit> optional])

datediff(endDate, startDate)

timestamp_add(unit, value, <timestamp expr>)

timestampadd(unit, value, expr)

timestamp_diff(<timestamp expr1>, <timestamp expr2>, unit)

timestampdiff(unit, start, end)

to_timestamp( <expr> )

to_timestamp(expr [, fmt] )

datetime(<expr>, <time zone>)

from_utc_timestamp(expr, timeZone)

from_unixtime(<expr>, [<unit> optional])

from_unixtime(unixTime [, fmt])

to_unix_timestamp( <expr> )

to_unix_timestamp(expr [, fmt] )

format_date( <expr>, format)

date_format(expr, fmt)

format_timestamp(<expr>, format)

date_format(expr, fmt)

extract( unit FROM <datetime expr>)

extract(field FROM source)

datepart( unit, <expr> )

date_part(field, expr)

current_timestamp + interval '8' minute

caldate + interval '1 second'

array_to_string( <expr>, delimiter)

array_join(array, delimiter [, nullReplacement])

e6data

Presto

current_date()

current_date

current_date(timezone)

current_date AT TIME ZONE timezone

current_timestamp()

current_timestamp

current_timestamp(timezone)

current_timestamp AT TIME ZONE timezone

last_day( <date/datetime expr> )

last_day_of_month(x)

date_trunc(unit, <expr> )

date_trunc(unit, x)

date_add(unit, value, <date expr>)

date_add(unit, value, timestamp)

date_diff( <date expr1>, <date expr2>, [<unit> optional])

date_diff(unit, timestamp1, timestamp2)

timestamp_add(unit, value, <timestamp expr>)

date_add(unit, value, timestamp)

timestamp_diff(<timestamp expr1>, <timestamp expr2>, unit)

date_diff(unit, timestamp1, timestamp2)

to_timestamp( <expr> )

to_timestamp(string, format)

datetime(<expr>, <time zone>)

from_unixtime(<expr>, [<unit> optional])

from_unixtime(unixtime)

to_unix_timestamp( <expr> )

to_unixtime(expr)

format_date( <expr>, format)

format_datetime(timestamp, format)

format_timestamp(<expr>, format)

format_datetime(timestamp, format)

extract( unit FROM <datetime expr>)

extract(field FROM x)

current_timestamp + interval '8' minute

timestamp '2012-10-31 01:00' + interval '1' month

array_to_string( <expr>, delimiter)

array_join(x, delimiter, null_replacement)

json_value( <json expr>, <json-path>)

json_extract_scalar(json, json_path)

e6data

Redshift

current_date()

current_date

current_date(timezone)

current_date AT TIME ZONE timezone

current_timestamp()

current_timestamp

current_timestamp(timezone)

current_timestamp AT TIME ZONE timezone

last_day( <date/datetime expr> )

LAST_DAY ( { date | timestamp } )

date_trunc(unit, <expr> )

DATE_TRUNC('unit', timestamp)

date_add(unit, value, <date expr>)

DATEADD( datepart, interval, {date|time|timetz|timestamp} )

date_diff( <date expr1>, <date expr2>, [<unit> optional])

DATEDIFF ( datepart, {date|time|timetz|timestamp}, {date|time|timetz|timestamp} )

timestamp_add(unit, value, <timestamp expr>)

DATEADD( datepart, interval, {date|time|timetz|timestamp} )

timestamp_diff(<timestamp expr1>, <timestamp expr2>, unit)

DATEDIFF ( datepart, {date|time|timetz|timestamp}, {date|time|timetz|timestamp} )

to_timestamp( <expr> )

to_timestamp (timestamp, format)

datetime(<expr>, <time zone>)

from_unixtime(<expr>, [<unit> optional])

timestamp 'epoch' + CAST(your_timestamp_column AS BIGINT)/1000 * interval '1 second'

to_unix_timestamp( <expr> )

extract(epoch from CURRENT_DATE)

format_date( <expr>, format)

TO_CHAR (timestamp_expression | numeric_expression , 'format')

format_timestamp(<expr>, format)

TO_CHAR (timestamp_expression | numeric_expression , 'format')

extract( unit FROM <datetime expr>)

EXTRACT ( datepart FROM { TIMESTAMP 'literal' | timestamp | time | timetz } )

datepart( unit, <expr> )

DATE_PART(datepart, {date|timestamp})

current_timestamp + interval '8' minute

caldate + interval '1 second'

json_value( <json expr>, <json-path>)

json_extract_path_text('json_string', 'path_elem' [,'path_elem'[, …] ] [, null_if_invalid ] )

e6data

Snowflake

current_date()

current_date(timezone)

convert_timezone('UTC','timestamp', current_date())

current_timestamp()

current_timestamp(timezone)

convert_timezone('UTC','timestamp', current_timestamp())

last_day( <date/datetime expr> )

LAST_DAY( <date_or_time_expr> [ , <date_part> ] )

date_trunc(unit, <expr> )

DATE_TRUNC( <date_or_time_part>, <date_or_time_expr> )

date_add(unit, value, <date expr>)

DATEADD( <date_or_time_part>, <value>, <date_or_time_expr> )

date_diff( <date expr1>, <date expr2>, [<unit> optional])

DATEDIFF( <date_or_time_part>, <date_or_time_expr1>, <date_or_time_expr2> )

timestamp_add(unit, value, <timestamp expr>)

TIMESTAMPADD( <date_or_time_part> , <time_value> , <date_or_time_expr> )

timestamp_diff(<timestamp expr1>, <timestamp expr2>, unit)

TIMESTAMPDIFF( <date_or_time_part> , <date_or_time_expr1> , <date_or_time_expr2> )

to_timestamp( <expr> )

datetime(<expr>, <time zone>)

CONVERT_TIMEZONE( <target_tz> , <source_timestamp> )

from_unixtime(<expr>, [<unit> optional])

TO_TIMESTAMP( epoch_sec )

to_unix_timestamp( <expr> )

date_part('epoch_second',current_timestamp())

format_date( <expr>, format)

TO_VARCHAR( <date_or_time_expr> [, '<format>' ] )

format_timestamp(<expr>, format)

TO_VARCHAR( <date_or_time_expr> [, '<format>' ] )

extract( unit FROM <datetime expr>)

EXTRACT( <date_or_time_part> FROM <date_or_time_expr> )

datepart( unit, <expr> )

DATE_PART( <date_or_time_part> , <date_or_time_expr> )

current_timestamp + interval '8' minute

caldate + interval '1 second'

array_to_string( <expr>, delimiter)

ARRAY_TO_STRING( <array> , <separator_string> )

json_value( <json expr>, <json-path>)

JSON_EXTRACT_PATH_TEXT( <column_identifier> , '<path_name>' )

PreviousStruct Functions NextConnectors & Drivers

Last updated 1 year ago