current_date function (Databricks SQL)
Returns the current date at the start of query evaluation.
current_date()
Arguments
This function takes no arguments.
Returns
A DATE.
The braces are optional.
Examples
> SELECT current_date() 2022-08-23 > SELECT current_date; 2022-08-23
now function (Databricks SQL)
- now function (Databricks SQL) | Databricks on AWS
- current_timestamp function (Databricks SQL) | Databricks on AWS
Returns the current timestamp at the start of query evaluation.
now()
Arguments
This function takes no arguments.
Returns
A TIMESTAMP.
Examples
> SELECT now() 2022-08-23T04:57:51.871+0000 > SELECT current_timestamp() > SELECT current_timestamp
to_date function (Databricks SQL)
Returns expr
cast to a date using an optional formatting.
to_date(expr [, fmt] )
Returns
A DATE.
> SELECT to_date('2022-08-24 07:00:00'); 2022-08-24 > SELECT to_date('2022-08-24', 'yyyy-MM-dd'); 2022-08-24
from_unixtime function (Databricks SQL)
Returns unixTime
in fmt
.
from_unixtime(unixTime [, fmt])
Arguments
unixTime
: A BIGINT expression representing seconds elapsed since 1969-12-31 at 16:00:00 (แต่เหมือนจะเป็น 1970-01-01 at 00:00:00).- fmt: An optional STRING expression with a valid format.
Returns
A STRING.
See Datetime patterns (Databricks SQL) for valid formats. The ‘yyyy-MM-dd HH:mm:ss’ pattern is used if omitted.
Examples
> SELECT from_unixtime(0); 1970-01-01 00:00:00 > SELECT from_unixtime(0, 'yyyy-MM-dd HH:mm:ss'); 1970-01-01 00:00:00
to_unix_timestamp function (Databricks SQL)
Returns the timestamp in expr
as a UNIX timestamp.
to_unix_timestamp(expr [, fmt] )
Arguments
expr
: A STRING expression representing a timestamp.- fmt: An optional format STRING expression.
Returns
A BIGINT.
If fmt
is supplied, it must conform with Datetime patterns (Databricks SQL).
If fmt
is not supplied, the function is a synonym for cast(expr AS TIMESTAMP)
.
If fmt
is malformed or its application does not result in a well formed timestamp, the function raises an error.
> SELECT to_unix_timestamp(current_date()) 1661299200 > SELECT to_unix_timestamp('2022-08-24', 'yyyy-MM-dd') 1661299200
> SELECT to_unix_timestamp(current_timestamp()) 1661328640 > SELECT to_unix_timestamp('2022-08-24 08:11:00', 'yyyy-MM-dd HH:mm:ss') 1661328660
> SELECT to_unix_timestamp(current_timestamp()) - to_unix_timestamp(current_date()) 29230