PgDateTimePart
Namespace: Ankus
Assembly: Ankus.Runtime.dll
Selects a PostgreSQL date_part or date_trunc field. Support depends on the temporal type and server version.
public enum PgDateTimePartFields
Section titled “Fields”Century
Section titled “Century”Calendar century.
Century = 0Day of month, or the interval day component.
Day = 1DayOfWeek
Section titled “DayOfWeek”Sunday-based day of week, zero through six.
DayOfWeek = 3DayOfYear
Section titled “DayOfYear”Day of year, starting at one.
DayOfYear = 4Decade
Section titled “Decade”Calendar decade.
Decade = 2Seconds relative to the Unix epoch, or interval duration under PostgreSQL’s comparison rules.
Epoch = 5Hour component.
Hour = 6IsoDayOfWeek
Section titled “IsoDayOfWeek”Monday-based ISO day of week, one through seven.
IsoDayOfWeek = 7IsoYear
Section titled “IsoYear”ISO week-numbering year.
IsoYear = 8Julian
Section titled “Julian”Julian date.
Julian = 9Microseconds
Section titled “Microseconds”Seconds including the fractional part, multiplied by one million.
Microseconds = 10Millennium
Section titled “Millennium”Calendar millennium.
Millennium = 11Milliseconds
Section titled “Milliseconds”Seconds including the fractional part, multiplied by one thousand.
Milliseconds = 12Minute
Section titled “Minute”Minute component.
Minute = 13Month of year, or the interval month component modulo twelve.
Month = 14Quarter
Section titled “Quarter”Quarter of year.
Quarter = 15Second
Section titled “Second”Seconds including the fractional part.
Second = 16TimeZone
Section titled “TimeZone”Seconds east of UTC.
TimeZone = 17TimeZoneHour
Section titled “TimeZoneHour”Hour component of the UTC offset.
TimeZoneHour = 18TimeZoneMinute
Section titled “TimeZoneMinute”Minute component of the UTC offset.
TimeZoneMinute = 19ISO week number.
Week = 20Year, with negative BC years and no year zero.
Year = 21