Teradata Package for Python Function Reference on VantageCloud Lake - end - 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 on VantageCloud Lake

Deployment
VantageCloud
Edition
Lake
Product
Teradata Package for Python
Release Number
20.00.00.11
Publication Date
August 2026
Content Type
Programming Reference
Publication ID
B700-4500-200K
ft:locale
en-US
ft:lastEdition
2026-08-13
ft:sourceId
FTML
dita:id
TeradataPython_FxRef_Lake_2000
Product Category
Teradata Vantage
teradataml.dataframe.sql.DataFrameColumn.end = end(self)
DESCRIPTION:
    Retrieves the ending date or timestamp from a PERIOD column.
 
PARAMETERS:
    None.
    
RETURNS:
    ColumnExpression.
 
RAISES:
    TeradataMlException.
 
EXAMPLES:
    # Load the data to run the example.
    >>> load_example_data("teradataml", "Employee_roles")
 
    # Create a DataFrame on 'employee_roles' table.
    >>> df = DataFrame("employee_roles")
 
    # Extract the ending date from the period column 'role_validity_period' 
    # and assign it to a new column.
    >>> df = df.assign(end_date_col = df['role_validity_period'].end())
    EmployeeID    EmployeeName   Department      Salary        role_validity_period         end_date_col
             1        John Doe           IT     100.000    ('20/01/01', '24/12/31')             24/12/31
             2      Jane Smith           DA     200.000    ('20/01/01', '99/12/31')             99/12/31
             3             Bob    Marketing     330.000    ('25/01/01', '99/12/31')             99/12/31
             3             Bob        Sales     300.000    ('24/01/01', '24/12/31')             24/12/31