Skip to main content
Pixeltable UDFs for DateType. Usage example: 
import pixeltable as pxt

t = pxt.get_table(...)
t.select(t.date_col.year, t.date_col.weekday()).collect()
View source on GitHub

​
udf add_days()

add_days(self: Date, n: Int) -> Date
Add n days to the date. Equivalent to date + timedelta(days=n).

​
udf day()

day(self: Date) -> Int
Between 1 and the number of days in the given month of the given year. Equivalent to date.day.

​
udf isocalendar()

isocalendar(self: Date) -> Json
Return a dictionary with three entries: 'year', 'week', and 'weekday'. Equivalent to date.isocalendar().

​
udf isoformat()

isoformat(
    self: Date,
    sep: String = 'T',
    timespec: String = 'auto'
) -> String
Return a string representing the date and time in ISO 8601 format. Equivalent to date.isoformat(). Parameters:
  • sep (String): Separator between date and time.
  • timespec (String): The number of additional terms in the output. See the date.isoformat() documentation for more details.

​
udf isoweekday()

isoweekday(self: Date) -> Int
Return the day of the week as an integer, where Monday is 1 and Sunday is 7. Equivalent to date.isoweekday().

​
udf make_date()

make_date(year: Int, month: Int, day: Int) -> Date
Create a date. Equivalent to datetime().

​
udf month()

month(self: Date) -> Int
Between 1 and 12 inclusive. Equivalent to date.month.

​
udf strftime()

strftime(self: Date, format: String) -> String
Return a string representing the date and time, controlled by an explicit format string. Equivalent to date.strftime(). Parameters:

​
udf toordinal()

toordinal(self: Date) -> Int
Return the proleptic Gregorian ordinal of the date, where January 1 of year 1 has ordinal 1. Equivalent to date.toordinal().

​
udf weekday()

weekday(self: Date) -> Int
Between 0 (Monday) and 6 (Sunday) inclusive. Equivalent to date.weekday().

​
udf year()

year(self: Date) -> Int
Between 1 and 9999 inclusive. (Between MINYEAR and MAXYEAR as defined by the Python datetime library). Equivalent to date.year.