pub enum ExtractField {
Show 23 variants
Year,
Month,
Day,
Hour,
Minute,
Second,
Microsecond,
Epoch,
Dow,
Isodow,
Doy,
Week,
Isoyear,
Quarter,
Decade,
Century,
Millennium,
Julian,
Millisecond,
Timezone,
TimezoneHour,
TimezoneMinute,
Other(String),
}Variants§
Year
Month
Day
Hour
Minute
Second
Microsecond
Epoch
Seconds since 1970-01-01 00:00:00 UTC (PG returns numeric; SPG keeps the integer convention — truncated seconds).
Dow
Day of week, 0 = Sunday … 6 = Saturday.
Isodow
ISO day of week, 1 = Monday … 7 = Sunday.
Doy
Day of year, 1-366.
Week
ISO 8601 week number, 1-53.
Isoyear
ISO 8601 week-numbering year (pairs with Week).
Quarter
Quarter, 1-4.
Decade
Year divided by 10 (floor).
Century
Century — 2001-2100 is century 21.
Millennium
Millennium — 2001-3000 is millennium 3.
Julian
Julian day number (truncated for timestamps).
Millisecond
Seconds and fraction in milliseconds (ss·1000 + frac).
Timezone
UTC offset in seconds — SPG sessions run UTC, so 0.
TimezoneHour
Hour component of the UTC offset — 0.
TimezoneMinute
Minute component of the UTC offset — 0.
Other(String)
v7.39 (round 253) — a field name the parser does not know. PG
resolves EXTRACT fields at RUNTIME and reports them with the
source type (unit "nosuch" not recognized for type timestamp without time zone, 22023), so the parser carries the raw name
instead of rejecting.
Trait Implementations§
Source§impl Clone for ExtractField
impl Clone for ExtractField
Source§fn clone(&self) -> ExtractField
fn clone(&self) -> ExtractField
1.0.0 (const: unstable) · Source§fn clone_from(&mut self, source: &Self)
fn clone_from(&mut self, source: &Self)
source. Read more