Module expr::scalar::func [−][src]
Re-exports
pub use impls::*;
Modules
Encoding and decoding support for various formats that represent binary data as text data.
Data type formatting functions.
Enums
Traits
Common set of methods for date component.
A description of an SQL unary function that operates on eagerly evaluated expressions
A description of an SQL unary function that has the ability to lazy evaluate its arguments
Common set of methods for time component.
A timestamp with both a date and a time component, but not necessarily a timezone component.
Functions
Constructs a new multidimensional array out of an arbitrary number of lower-dimensional arrays.
Constructs a new zero or one dimensional array out of an arbitrary number of scalars.
Casts between two list types by casting each element of a
(“list1”) using
cast_expr
and collecting the results into a new list (“list2”).
Parses a named timezone like EST
or America/New_York
, or a fixed-offset timezone like -05:00
.
Converts the time datum b
, which is assumed to be in UTC, to the timezone that the interval datum a
is assumed
to represent. The interval is not allowed to hold months, but there are no limits on the amount of seconds.
The interval acts like a chrono::FixedOffset
, without the -86,400 < x < 86,400
limitation.
Converts the timestamp datum b
, which is assumed to be in the time of the timezone datum a
to a timestamptz
in UTC. The interval is not allowed to hold months, but there are no limits on the amount of seconds.
The interval acts like a chrono::FixedOffset
, without the -86,400 < x < 86,400
limitation.
Converts the UTC timestamptz datum b
, to the local timestamp of the timezone datum a
.
The interval is not allowed to hold months, but there are no limits on the amount of seconds.
The interval acts like a chrono::FixedOffset
, without the -86,400 < x < 86,400
limitation.
Converts the time t
, which is assumed to be in UTC, to the timezone tz
.
For example, EST
and 17:39:14
would return 12:39:14
.
Converts the timestamp dt
, which is assumed to be in the time of the timezone tz
to a timestamptz in UTC.
This operation is fallible because certain timestamps at timezones that observe DST are simply impossible or
ambiguous. In case of ambiguity (when a hour repeats) we will prefer the latest variant, and when an hour is
impossible, we will attempt to fix it by advancing it. For example, EST
and 2020-11-11T12:39:14
would return
2020-11-11T17:39:14Z
. A DST observing timezone like America/New_York
would cause the following DST anomalies:
2020-11-01T00:59:59
-> 2020-11-01T04:59:59Z
and 2020-11-01T01:00:00
-> 2020-11-01T06:00:00Z
2020-03-08T02:59:59
-> 2020-03-08T07:59:59Z
and 2020-03-08T03:00:00
-> 2020-03-08T07:00:00Z
Converts the UTC timestamptz utc
to the local timestamp of the timezone tz
.
For example, EST
and 2020-11-11T17:39:14Z
would return 2020-11-11T12:39:14
.