DateTimeField in sqlparser::ast

DateTimeField in sqlparser::ast - Rust

Enum DateTimeField

pub enum DateTimeField {
Show 44 variants    Year,
    Years,
    Month,
    Months,
    Week(Option<Ident>),
    Weeks,
    Day,
    DayOfWeek,
    DayOfYear,
    Days,
    Date,
    Datetime,
    Hour,
    Hours,
    Minute,
    Minutes,
    Second,
    Seconds,
    Century,
    Decade,
    Dow,
    Doy,
    Epoch,
    Isodow,
    Isoyear,
    IsoWeek,
    Julian,
    Microsecond,
    Microseconds,
    Millenium,
    Millennium,
    Millisecond,
    Milliseconds,
    Nanosecond,
    Nanoseconds,
    Quarter,
    Time,
    Timezone,
    TimezoneAbbr,
    TimezoneHour,
    TimezoneMinute,
    TimezoneRegion,
    NoDateTime,
    Custom(Ident),
}

Expand description

Represents the date/time fields used by functions like EXTRACT.

Each variant corresponds to a supported date/time part (for example YEAR, MONTH, DAY, etc.). The Custom variant allows arbitrary identifiers (e.g. dialect-specific abbreviations).

YEAR

YEARS (plural form)

MONTH

MONTHS (plural form)

WEEK, optionally followed by a weekday, e.g. WEEK(MONDAY).

BigQuery

WEEKS (plural form)

DAY

DAYOFWEEK

DAYOFYEAR

DAYS (plural form)

DATE

DATETIME

HOUR

HOURS (plural form)

MINUTE

MINUTES (plural form)

SECOND

SECONDS (plural form)

CENTURY

DECADE

DOW (day of week short form)

DOY (day of year short form)

EPOCH

ISODOW

ISOYEAR

ISOWEEK

JULIAN

MICROSECOND

MICROSECONDS (plural form)

MILLENIUM (alternate spelling)

MILLENNIUM (alternate spelling)

MILLISECOND

MILLISECONDS (plural form)

NANOSECOND

NANOSECONDS (plural form)

QUARTER

TIME

TIMEZONE

TIMEZONE_ABBR

TIMEZONE_HOUR

TIMEZONE_MINUTE

TIMEZONE_REGION

NODATETIME indicates no date/time part

Arbitrary abbreviation or custom date-time part.

EXTRACT(q FROM CURRENT_TIMESTAMP)

Snowflake