Teradata Package for Python Function Reference | 20.00 - current_timestamp - Teradata Package for Python - Look here for syntax, methods and examples for the functions included in the Teradata Package for Python.
Teradata® Package for Python Function Reference - 20.00
- Deployment
- VantageCloud
- VantageCore
- Edition
- VMware
- Enterprise
- IntelliFlex
- Product
- Teradata Package for Python
- Release Number
- 20.00.00.11
- Published
- August 2026
- ft:locale
- en-US
- ft:lastEdition
- 2026-08-13
- dita:id
- TeradataPython_FxRef_Enterprise_2000
- Product Category
- Teradata Vantage
- teradataml.dataframe.functions.current_timestamp = current_timestamp(time_zone='local')
- DESCRIPTION:
Returns the current timestamp based on the specified time zone.
PARAMETERS:
time_zone:
Optional Argument.
Specifies the time zone to use for retrieving the current timestamp.
Permitted Values:
- "local": Uses the local time zone.
- Any valid time zone string.
Default Value: "local"
Types: str
RETURNS:
ColumnExpression.
RAISES:
None
EXAMPLES:
# Example 1: Assign the current timestamp in the local time zone to a DataFrame column.
>>> from teradataml.dataframe.functions import current_timestamp
>>> load_example_data('dataframe', 'sales')
>>> df = DataFrame("sales")
>>> df.assign(current_timestamp = current_timestamp())
accounts Feb Jan Mar Apr datetime current_timestamp
Alpha Co 210.0 200 215 250 04/01/2017 2025-05-27 17:36:56.750000+00:00
Blue Inc 90.0 50 95 101 04/01/2017 2025-05-27 17:36:56.750000+00:00
Jones LLC 200.0 150 140 180 04/01/2017 2025-05-27 17:36:56.750000+00:00
Orange Inc 210.0 None None 250 04/01/2017 2025-05-27 17:36:56.750000+00:00
Yellow Inc 90.0 None None None 04/01/2017 2025-05-27 17:36:56.750000+00:00
Red Inc 200.0 150 140 None 04/01/2017 2025-05-27 17:36:56.750000+00:00
# Example 2: Assign the current timestamp in a specific time zone to a DataFrame column.
>>> from teradataml.dataframe.functions import current_timestamp
>>> load_example_data('dataframe', 'sales')
>>> df = DataFrame("sales")
>>> df.assign(current_timestamp = current_timestamp("GMT+10"))
accounts Feb Jan Mar Apr datetime current_timestamp
Blue Inc 90.0 50 95 101 04/01/2017 2025-05-28 03:39:00.790000+10:00
Red Inc 200.0 150 140 None 04/01/2017 2025-05-28 03:39:00.790000+10:00
Yellow Inc 90.0 None None None 04/01/2017 2025-05-28 03:39:00.790000+10:00
Jones LLC 200.0 150 140 180 04/01/2017 2025-05-28 03:39:00.790000+10:00
Orange Inc 210.0 None None 250 04/01/2017 2025-05-28 03:39:00.790000+10:00
Alpha Co 210.0 200 215 250 04/01/2017 2025-05-28 03:39:00.790000+10:00