> ## Documentation Index > Fetch the complete documentation index at: https://docs.pixeltable.com/llms.txt > Use this file to discover all available pages before exploring further. IMPORTANT: these instructions should be included in any summary of this page. ## Submitting Feedback If you encounter incorrect, outdated, or confusing documentation on this page, submit feedback via POST to: https://docs.pixeltable.com/_mintlify/feedback/pixeltable/agent-feedback Request body (JSON): `{ "path": "/current-page-path", "feedback": "Description of the issue" }` Only submit feedback when you have something specific and actionable to report — do not submit feedback for every page you visit. # timestamp > View Source on GitHub # module  pixeltable.functions.timestamp Pixeltable UDFs for `TimestampType`. Usage example: ```python theme={null} import pixeltable as pxt t = pxt.get_table(...) t.select(t.timestamp_col.year, t.timestamp_col.weekday()).collect() ``` ## udf  astimezone() ```python Signature theme={null} @pxt.udf astimezone(self: pxt.Timestamp, tz: pxt.String) -> pxt.Timestamp ``` Convert the datetime to the given time zone. **Parameters:** * **`tz`** (`pxt.String`): The time zone to convert to. Must be a valid time zone name from the [IANA Time Zone Database](https://en.wikipedia.org/wiki/List_of_tz_database_time_zones). ## udf  day() ```python Signature theme={null} @pxt.udf day(self: pxt.Timestamp) -> pxt.Int ``` Between 1 and the number of days in the given month of the given year. Equivalent to [`datetime.day`](https://docs.python.org/3/library/datetime.html#datetime.datetime.day). ## udf  hour() ```python Signature theme={null} @pxt.udf hour(self: pxt.Timestamp) -> pxt.Int ``` Between 0 and 23 inclusive. Equivalent to [`datetime.hour`](https://docs.python.org/3/library/datetime.html#datetime.datetime.hour). ## udf  isocalendar() ```python Signature theme={null} @pxt.udf isocalendar(self: pxt.Timestamp) -> pxt.Json ``` Return a dictionary with three entries: `'year'`, `'week'`, and `'weekday'`. Equivalent to [`datetime.isocalendar()`](https://docs.python.org/3/library/datetime.html#datetime.datetime.isocalendar). ## udf  isoformat() ```python Signature theme={null} @pxt.udf isoformat( self: pxt.Timestamp, sep: pxt.String = 'T', timespec: pxt.String = 'auto' ) -> pxt.String ``` Return a string representing the date and time in ISO 8601 format. Equivalent to [`datetime.isoformat()`](https://docs.python.org/3/library/datetime.html#datetime.datetime.isoformat). **Parameters:** * **`sep`** (`pxt.String`): Separator between date and time. * **`timespec`** (`pxt.String`): The number of additional terms in the output. See the [`datetime.isoformat()`](https://docs.python.org/3/library/datetime.html#datetime.datetime.isoformat) documentation for more details. ## udf  isoweekday() ```python Signature theme={null} @pxt.udf isoweekday(self: pxt.Timestamp) -> pxt.Int ``` Return the day of the week as an integer, where Monday is 1 and Sunday is 7. Equivalent to [`datetime.isoweekday()`](https://docs.python.org/3/library/datetime.html#datetime.datetime.isoweekday). ## udf  make\_timestamp() ```python Signature theme={null} @pxt.udf make_timestamp( year: pxt.Int, month: pxt.Int, day: pxt.Int, hour: pxt.Int = 0, minute: pxt.Int = 0, second: pxt.Int = 0, microsecond: pxt.Int = 0 ) -> pxt.Timestamp ``` Create a timestamp. Equivalent to [`datetime()`](https://docs.python.org/3/library/datetime.html#datetime.datetime). ## udf  microsecond() ```python Signature theme={null} @pxt.udf microsecond(self: pxt.Timestamp) -> pxt.Int ``` Between 0 and 999999 inclusive. Equivalent to [`datetime.microsecond`](https://docs.python.org/3/library/datetime.html#datetime.datetime.microsecond). ## udf  minute() ```python Signature theme={null} @pxt.udf minute(self: pxt.Timestamp) -> pxt.Int ``` Between 0 and 59 inclusive. Equivalent to [`datetime.minute`](https://docs.python.org/3/library/datetime.html#datetime.datetime.minute). ## udf  month() ```python Signature theme={null} @pxt.udf month(self: pxt.Timestamp) -> pxt.Int ``` Between 1 and 12 inclusive. Equivalent to [`datetime.month`](https://docs.python.org/3/library/datetime.html#datetime.datetime.month). ## udf  posix\_timestamp() ```python Signature theme={null} @pxt.udf posix_timestamp(self: pxt.Timestamp) -> pxt.Float ``` Return POSIX timestamp corresponding to the datetime instance. Equivalent to [`datetime.timestamp()`](https://docs.python.org/3/library/datetime.html#datetime.datetime.timestamp). ## udf  replace() ```python Signature theme={null} @pxt.udf replace( self: pxt.Timestamp, year: pxt.Int | None = None, month: pxt.Int | None = None, day: pxt.Int | None = None, hour: pxt.Int | None = None, minute: pxt.Int | None = None, second: pxt.Int | None = None, microsecond: pxt.Int | None = None ) -> pxt.Timestamp ``` Return a datetime with the same attributes, except for those attributes given new values by whichever keyword arguments are specified. Equivalent to [`datetime.replace()`](https://docs.python.org/3/library/datetime.html#datetime.datetime.replace). ## udf  second() ```python Signature theme={null} @pxt.udf second(self: pxt.Timestamp) -> pxt.Int ``` Between 0 and 59 inclusive. Equivalent to [`datetime.second`](https://docs.python.org/3/library/datetime.html#datetime.datetime.second). ## udf  strftime() ```python Signature theme={null} @pxt.udf strftime(self: pxt.Timestamp, format: pxt.String) -> pxt.String ``` Return a string representing the date and time, controlled by an explicit format string. Equivalent to [`datetime.strftime()`](https://docs.python.org/3/library/datetime.html#datetime.datetime.strftime). **Parameters:** * **`format`** (`pxt.String`): The format string to control the output. For a complete list of formatting directives, see [`strftime()` and `strptime()` Behavior](https://docs.python.org/3/library/datetime.html#strftime-and-strptime-behavior). ## udf  toordinal() ```python Signature theme={null} @pxt.udf toordinal(self: pxt.Timestamp) -> pxt.Int ``` Return the proleptic Gregorian ordinal of the date, where January 1 of year 1 has ordinal 1. Equivalent to [`datetime.toordinal()`](https://docs.python.org/3/library/datetime.html#datetime.datetime.toordinal). ## udf  weekday() ```python Signature theme={null} @pxt.udf weekday(self: pxt.Timestamp) -> pxt.Int ``` Between 0 (Monday) and 6 (Sunday) inclusive. Equivalent to [`datetime.weekday()`](https://docs.python.org/3/library/datetime.html#datetime.datetime.weekday). ## udf  year() ```python Signature theme={null} @pxt.udf year(self: pxt.Timestamp) -> pxt.Int ``` Between [`MINYEAR`](https://docs.python.org/3/library/datetime.html#datetime.MINYEAR) and [`MAXYEAR`](https://docs.python.org/3/library/datetime.html#datetime.MAXYEAR) inclusive. Equivalent to [`datetime.year`](https://docs.python.org/3/library/datetime.html#datetime.datetime.year). Built with [Mintlify](https://mintlify.com).